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)

Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.