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:
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:5.1 OS:Mac OS X
Assigned to: Assigned Account CPU Architecture:Any
Tags: install, mysql_upgrade, upgrade

[21 May 2007 20:21] Jim Barcelona
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
[23 May 2007 9:30] Sveta Smirnova
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)
[23 Jun 2007 23:00] Bugs System
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".