MySQL Bugs: #28575: Running mysql_upgrade locks user out of database

Bug #28575	Running mysql_upgrade locks user out of database
Submitted:	21 May 2007 20:21	Modified:	23 Jun 2007 9:30
Reporter:	Jim Barcelona	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	5.1	OS:	MacOS
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	install, mysql_upgrade, upgrade

Description:
I ran mysql_upgrade in order to uprade from 5.0 to 5.1. When I tried to log in using mysql I discovered none of my user names or passwords worked.

How to repeat:
install mysql 5.0
set password for root
install mysql 5.1 using mysql_upgrade
startup mysqld
try to log in using
mysql -uroot -p -h localhost

you won't be able to

Thank you for the report.

I can not repeat described behaviour.

Please provide more information how to repeat the case.

I mean:
- full command line you use each time when you run specific command
- output of mysql_upgrade command
- output of SELECT user, host, password FROM mysql.user before and after upgrade (afrter upgrade you can run mysqld --skip-grant-tables to get access to the database)

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".