Bug #6491 access denied for user 'root'@'%' to database 'mysql'
Submitted: 8 Nov 2004 1:12 Modified: 6 Feb 2005 14:23
Reporter: Johnathon Lyons Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:MySQL administrator 1.0.14 OS:Windows (Windows XP)
Assigned to: Bugs System CPU Architecture:Any

[8 Nov 2004 1:12] Johnathon Lyons
Description:
I installed latest releases of MySQL 4.1 and then MySQL administrator 1.0.14

I open MySQL administrator and wanted to change my root password.

The options in the users pane were greyed out on the right.

I clicked 'new user' and named the new user root.

Then in the left pane at the bottom I see 2 root users!

Later, when I open MySQL administrator again I get a message saying...

could not fetch usernames

access denied for user 'root'@'%' to database 'mysql'

How to repeat:
Follow description

Suggested fix:
Disallow duplicate usernames or add code to deal with duplicate usernames
[6 Jan 2005 14:23] MySQL Verification Team
Hi,

Sorry for the delayed reply.
Can you test it with latest version of MySQL Administrator and see if the problem still exists?
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[22 May 2005 19:13] Glen Jones
Hi,

I have downloaded version 1.0.20 for the Mac OSX 10.3 Panther with all the patches.
I also get this problem.

Could not retrieve user list:
Access denied for user ''@'localhost' to database 'mysql' (error 1044)

In short try to change user accounts up pops a dialog as mentioned before.

The panel/form is then inactive as mentioned earlier

The Console Log says:
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /sw/lib/libglib-2.0.0.dylib  (No such file or directory, errno = 2)
2005-05-22 19:53:04.553 MySQL Administrator[3750] Could not find image named `adduser_normal.tiff'.
2005-05-22 19:53:04.557 MySQL Administrator[3750] Could not find image named `adduser_pressed.tiff'.
2005-05-22 19:53:04.565 MySQL Administrator[3750] Could not find image named `deluser_normal.tiff'.
2005-05-22 19:53:04.568 MySQL Administrator[3750] Could not find image named `deluser_pressed.tiff'.
2005-05-22 19:53:04.572 MySQL Administrator[3750] Could not find image named `addhost_normal.tiff'.
2005-05-22 19:53:04.576 MySQL Administrator[3750] Could not find image named `addhost_pressed.tiff'.
2005-05-22 19:53:04.582 MySQL Administrator[3750] Could not find image named `delhost_normal.tiff'.
2005-05-22 19:53:04.585 MySQL Administrator[3750] Could not find image named `delhost_pressed.tiff'.

After Running it a few times I get this

Mac OS X Version 10.3.9 (Build 7W98)
2005-05-22 17:39:57 +0100
2005-05-22 17:40:01.101 Personal Firewall Agent[513] Norton Personal Firewall Agent (513) launched.
2005-05-22 19:17:37.123 MySQL Administrator[3208] Could not find image named `adduser_normal.tiff'.
2005-05-22 19:17:37.126 MySQL Administrator[3208] Could not find image named `adduser_pressed.tiff'.
2005-05-22 19:17:37.132 MySQL Administrator[3208] Could not find image named `deluser_normal.tiff'.
2005-05-22 19:17:37.135 MySQL Administrator[3208] Could not find image named `deluser_pressed.tiff'.
2005-05-22 19:17:37.139 MySQL Administrator[3208] Could not find image named `addhost_normal.tiff'.
2005-05-22 19:17:37.143 MySQL Administrator[3208] Could not find image named `addhost_pressed.tiff'.
2005-05-22 19:17:37.147 MySQL Administrator[3208] Could not find image named `delhost_normal.tiff'.
2005-05-22 19:17:37.151 MySQL Administrator[3208] Could not find image named `delhost_pressed.tiff'.
2005-05-22 19:19:46.937 MySQL Administrator[3345] Could not find image named `adduser_normal.tiff'.
2005-05-22 19:19:46.940 MySQL Administrator[3345] Could not find image named `adduser_pressed.tiff'.
2005-05-22 19:19:46.947 MySQL Administrator[3345] Could not find image named `deluser_normal.tiff'.
2005-05-22 19:19:46.950 MySQL Administrator[3345] Could not find image named `deluser_pressed.tiff'.
2005-05-22 19:19:46.954 MySQL Administrator[3345] Could not find image named `addhost_normal.tiff'.
2005-05-22 19:19:46.957 MySQL Administrator[3345] Could not find image named `addhost_pressed.tiff'.
2005-05-22 19:19:46.962 MySQL Administrator[3345] Could not find image named `delhost_normal.tiff'.
2005-05-22 19:19:46.965 MySQL Administrator[3345] Could not find image named `delhost_pressed.tiff'.
2005-05-22 19:27:18.222 MySQL Administrator[3360] Could not find image named `adduser_normal.tiff'.
2005-05-22 19:27:18.226 MySQL Administrator[3360] Could not find image named `adduser_pressed.tiff'.
2005-05-22 19:27:18.234 MySQL Administrator[3360] Could not find image named `deluser_normal.tiff'.
2005-05-22 19:27:18.238 MySQL Administrator[3360] Could not find image named `deluser_pressed.tiff'.
2005-05-22 19:27:18.241 MySQL Administrator[3360] Could not find image named `addhost_normal.tiff'.
2005-05-22 19:27:18.244 MySQL Administrator[3360] Could not find image named `addhost_pressed.tiff'.
2005-05-22 19:27:18.249 MySQL Administrator[3360] Could not find image named `delhost_normal.tiff'.
2005-05-22 19:27:18.253 MySQL Administrator[3360] Could not find image named `delhost_pressed.tiff'.
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /sw/lib/libglib-2.0.0.dylib  (No such file or directory, errno = 2)
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /sw/lib/libglib-2.0.0.dylib  (No such file or directory, errno = 2)
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /sw/lib/libglib-2.0.0.dylib  (No such file or directory, errno = 2)
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /sw/lib/libglib-2.0.0.dylib  (No such file or directory, errno = 2)
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /sw/lib/libglib-2.0.0.dylib  (No such file or directory, errno = 2)
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /sw/lib/libglib-2.0.0.dylib  (No such file or directory, errno = 2)
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /sw/lib/libglib-2.0.0.dylib  (No such file or directory, errno = 2)
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /sw/lib/libglib-2.0.0.dylib  (No such file or directory, errno = 2)
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /sw/lib/libglib-2.0.0.dylib  (No such file or directory, errno = 2)
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /sw/lib/libglib-2.0.0.dylib  (No such file or directory, errno = 2)
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /sw/lib/libglib-2.0.0.dylib  (No such file or directory, errno = 2)
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /sw/lib/libglib-2.0.0.dylib  (No such file or directory, errno = 2)
2005-05-22 19:53:04.553 MySQL Administrator[3750] Could not find image named `adduser_normal.tiff'.
2005-05-22 19:53:04.557 MySQL Administrator[3750] Could not find image named `adduser_pressed.tiff'.
2005-05-22 19:53:04.565 MySQL Administrator[3750] Could not find image named `deluser_normal.tiff'.
2005-05-22 19:53:04.568 MySQL Administrator[3750] Could not find image named `deluser_pressed.tiff'.
2005-05-22 19:53:04.572 MySQL Administrator[3750] Could not find image named `addhost_normal.tiff'.
2005-05-22 19:53:04.576 MySQL Administrator[3750] Could not find image named `addhost_pressed.tiff'.
2005-05-22 19:53:04.582 MySQL Administrator[3750] Could not find image named `delhost_normal.tiff'.
2005-05-22 19:53:04.585 MySQL Administrator[3750] Could not find image named `delhost_pressed.tiff'.

All other logs seem to be blank, I'm not sure where to look in the Admin dir.... for your app...
[22 May 2005 19:23] Glen Jones
Do you depend on any libs from Fink?

Because I don't use any of thier libs and apps at the moment....