MySQL Bugs: #62256: mysql_upgrade should convert Host values in mysql.user to lower case

Bug #62256	mysql_upgrade should convert Host values in mysql.user to lower case
Submitted:	24 Aug 2011 21:52	Modified:	25 Aug 2011 3:36
Reporter:	Hartmut Holzgraefe	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Security: Privileges	Severity:	S3 (Non-critical)
Version:	>= 5.1.53	OS:	Linux
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Starting with 5.1.53 GRANT, CREATE USER and DROP USER convert the host name part of user names to lower case so that no upper case characters should end up in the Host column of mysql.user anymore (and DROP USER can only drop users with all lower case host name part, see bug #62254).

Nothing takes care of changing legacy entries with upper case characters from pre-5.1.53 installations to all lower case though.

How to repeat:
...

Suggested fix:
Make mysql_upgrade run

  UPDATE mysql.user SET Host = LOWER( Host ); 

as part of the upgrade procedure.

Thank you for the problem report and suggested solution.