MySQL Bugs: #51464: Newly added user is not able to connect to MySql 5.1.43 from Workbench

Bug #51464	Newly added user is not able to connect to MySql 5.1.43 from Workbench
Submitted:	24 Feb 2010 16:01	Modified:	1 Mar 2010 22:12
Reporter:	Roger Appleby	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.15 OSS Rev 5053	OS:	Windows (Windows 7 x64)
Assigned to:		CPU Architecture:	Any

Description:
 I have installed all the above on a new HP dv8 8Gb Ram, 1 Tb disk and the new i7 (quad core/8core) CPU. I have no issues with the DB, but when I create users - they are unable to connect - only root - I have disabled the firewall - no change.

Even in the workbench - I cannot connect to the new users. This is all out of the box, can someone give me a hint - I was thinking the JDBC driver - but I cannot find anything on the net.

How to repeat:
create a new user - apply, add schema and rights to the user - apply
add user to the query browser and create connection - unable to connect.

If you go back and reapply the password to the user - it will work.
looks like the second action resets the password to null when you apply the rights.

I have created several users - all the same - resetting the password fixed them every time.

Suggested fix:
Work around is to come back after setting all the rights and privs - and re-entering the password and apply it.  This applies to any changes made to the user - even after the first creation.

This is a duplicate of Bug# 50983 (which has a misleading synopsis)