MySQL Bugs: #13138: No access to user adminstration

Bug #13138	No access to user adminstration
Submitted:	13 Sep 2005 12:12	Modified:	17 Sep 2007 12:27
Reporter:	Thomas Schulz	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.1.2, 1.2.12	OS:	Linux (Linux (Suse 9.3))
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
When selecting the menu item "User Administration", an error message appears: "Could not retrieve user privilege information.".

The connected user has the correct rights to perform that function and previous version 1.0.22a allows user adminstration at this item.

How to repeat:
Selecting an other item an then selecting the menu item "User Administration" again.

Thanks for your bug report.  I was able to reproduce this bug under FC4

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

I'm running Fedora Core 5 (Linux BrainIac 2.6.16-1.2111_FC5 #1 Thu May 4 21:16:58 EDT 2006 i686 i686 i386 GNU/Linux) with mysql-administrator.i386 0:1.1.6-3.fc5 and am experiencing this same problem.

I have the same issue on FC5. Is there a workaround?

With a newer version (actual 1.1.10) this does not happens anymore.

I am currently running 5.0.22 and I have tried several of the clients with the same "Could not retrieve user privilege information." error.  I suspect this isn't a client related issue more so than it is a server issue as I am getting some rather strange results utilizing other clients (including web based).  It would appear to be perhaps something in the mysql database (within MySQL server) with accounts not being handled correctly?  

If you have a workaournd that would be great.

I'm experiencing symptoms.  Basically, the environment in which I'm working is;-
     Client:-
          * Linux - 2.6.15 - 1.2054_FC5
* MySQL Client - 5.0.22
     Server:-
          * Linux - 2.6.15 - 1.2054_FC5
          * MySQL Server - 5.0.22

* MySQL Administrator - 1.1.10

I access MySql Administrator by leaving the username / password fields blank.  Anything else fails.

Using the similar MySQL versions under Microsoft/XP-Home (SPII), everything works fine.

Sorry folks.  Delete the abvoe reference to Windows as they are earlier version.

Sorry folks.  Delete the abvoe reference to Windows as they are earlier version.

Problem persists on FC5, mysql-administrator-1.1.10-2.fc5, mysql-5.0.27-1.fc5

Problem persists after replacing the Fedora RPMs with the ones distributed by mySql:

mysql-administrator.i386 0:5.0r8-1fc5 mysql-gui-tools.i386 0:5.0r8-1fc5 mysql-query-browser.i386 0:5.0r8-1fc5 mysql-workbench.i386 0:5.0r8-1fc5

Should this bug be reopened?

Re-opening because of bug #30783.

I can't repeat this issue on FC 6 and MA 1.2.12.

I was able to fix this by running the script:

/usr/bin/mysql_fix_privilege_tables

I am running:
FC6
MA 1.2.12
mysql.i386 5.0.27-1.fc6

Hope it helps,

Mike Laporte

I get the following error when trying to fix using my_sql_privilege, with password/no password/root account/myaccount
I am running Mysql Admin:1.2.12 on Ubuntu 8.10. 

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Got a failure from command:
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
Please check the above output and try again.

If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option