MySQL Bugs: #3509: Mysqladministrator add new users-adding new users w/pw not working w/client

Bug #3509	Mysqladministrator add new users-adding new users w/pw not working w/client
Submitted:	19 Apr 2004 20:00	Modified:	2 Jun 2004 15:26
Reporter:	Patricia Young	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.0.3 Alpha	OS:	Microsoft Windows (Windows XP)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
The Mysql Administrator does not recognize new connections with passwords. The Mysql Administrator also created two new super users. The Global and other Schema seem to work assigning privileges, but the new users are not recognized on Mysql Client when passwords and/or database are specified. The error 1044 access for user ''@'localhost' to database newschool and another error 1045(28000) 'access denied for user 'Patricia'@localhost (using password: yes').

I tried this with service grant table skip on and off. Moved two database folders into mysql\data. User root was automatically updated. Was not able to get the privileges that was granted in MysqlAdminsistrator to super user Patricia and Patilotus09 to work after reload and Flush Privileges after shutdown and system reboot.

Mysql Client allows sign on with the two new super users but only gives them minimal privileges and only when -p is ommited. None of the newly assigned databases were available with signon.

How to repeat:
Step 1:

create two new super users. In MysqlAdministrator.

Step 2:

move new new folders with databases already in existance to mysql\data.

Step 3:

log into MysqlAdministrator and assign the new databases to the two new super users.

Step 4:

log into mysql with one of the two new users.

show databases;

expect: the new databases not to appear. If the new databases show up, then the replication of the problem has failed. If the new databases don't show then the problem has been replicated.

Suggested fix:
The product must provide up to date User Administration parameters for users across the different products. Some how the product is only doing part of the specified function at my site.

Client is version 5.0 Alpha.

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