Deleting/renaming root account hides objects
| User, date | Message |
|---|---|
|
Written by Joselitux
8 months ago Category: General 17 posts since Mon, 22 Oct 12 |
Hello First of all Thanks for such excellent software. I've found an odd behaviour when deleting or renaming root account. (Creating a new account with same privileges than root named "whateveryouwant") Latest versión to date (7.0 stable) if you delete or rename root account on a fairly used mysql server (many tables and databases) when login with the new root-like account can't see any of the previously created tables inside the databases, even when the new user has ALL PRIVILEGES. The tree shows databases but can't access to objects inside. No error is displayed, just a blank plain empty tree is shown. Any other mysql client shows tables with no problem at all login with the new user (tested TOAD, mysqlWorkbench, dbeaver and sqldbx), so I think this is a heidisql issue Steps to reproduce the issue (be carreful, don't do in a production server): 1- create a root-like account vía renaming root or cloning root account. 2- delete original root account 3- exit heidisql 4- login using the recently created root-like account 5- navigate through object tree |
|
Written by ansgar
8 months ago 4020 posts since Fri, 07 Apr 06 |
Not reproducible here. What I did was clicking "Clone" on the root@127.0.0.1 user, on my local MySQL 5.5.8 server, gave it the username "ruth". Can log in with that user, see everything. The user creation looked as follows: CREATE USER 'ruth'@'localhost'; |
|
Written by ansgar
8 months ago 4020 posts since Fri, 07 Apr 06 |
Ah, probably noticable: I'm not running Heidi 7.0 stable, but the latest build (7.0.0.4217). |
|
Written by ansgar
8 months ago 4020 posts since Fri, 07 Apr 06 |
r3917 (pre-7.0 commit) fixed non-overtaken privileges when clicking the "Clone" button. But as you say you run 7.0 stable (= r4053) you should already have that fix. |
|
Written by Joselitux
8 months ago 17 posts since Mon, 22 Oct 12 |
would be very interesting to check if deleting root account (rather than clone) have that fixed too. thanks |
|
Written by Joselitux
8 months ago 17 posts since Mon, 22 Oct 12 |
Tested with latest build (7.0.0.4217) deleting root account still suffering that issue any hint? |
|
Written by ansgar
8 months ago 4020 posts since Fri, 07 Apr 06 |
Please post the GRANT command which is executed during the click on "save" on the cloned user. |
|
Written by Joselitux
8 months ago 17 posts since Mon, 22 Oct 12 |
Hi folks! the issue is when DELETING the root account, as noted in the procedure below. Not cloning. To be more specific: 1.- create a new account. Give ALL privileges. 2.- Delete root account 3.- exit heidi 4.- open heidi a create session with the new account 5.- Databasess show no data (0 B) |
|
Written by ansgar
8 months ago 4020 posts since Fri, 07 Apr 06 |
And again, sigh: Please post the GRANT command which is executed during the click on "save" on the cloned user. |
|
Written by ansgar
8 months ago 4020 posts since Fri, 07 Apr 06 |
... typo: not the cloned, but the new created user. |
|
Written by Joselitux
8 months ago 17 posts since Mon, 22 Oct 12 |
here: GRANT EXECUTE, PROCESS, SELECT, SHOW DATABASES, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TABLESPACE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, CREATE USER, FILE, LOCK TABLES, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SHUTDOWN, SUPER ON *.* TO 'new_root'@'localhost' WITH GRANT OPTION; |
|
Written by ansgar
8 months ago 4020 posts since Fri, 07 Apr 06 |
Ok, thanks. Just did exactly that (removed unsupported TABLESPACE, EVENT and TRIGGER for our old 5.0 server), and connected successfully. Can see everything, in all databases, all tables, no problem. |
|
Written by Joselitux
8 months ago 17 posts since Mon, 22 Oct 12 |
maybe it's an issue for 5.5 server only.... |
|
Please login to leave a reply, or register at first. |