Bug #14324 all passwort's/hostnames are invalid after update to 5.0.15
Submitted: 26 Oct 2005 9:56 Modified: 27 Oct 2005 8:30
Reporter: Frank Büttner Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.15 OS:Linux (Fedora Core 3)
Assigned to: Valeriy Kravchuk CPU Architecture:Any

[26 Oct 2005 9:56] Frank Büttner
After update from 4.1.14 to 5.0.15 all user and root accounts for the server are invalid. Every user that try's to connect to the DB will get an error about wrong password or that the host is not allowd to connect. The same problem is when I try to connect to the DB on the local server via the mysql or mysqladmin tool. The database is ok. While when I downgrade to 4.1.14 all users and connect. And local conect on the server is also posible.

How to repeat:
upgrade from 4.1.14 to 5.0.15
[26 Oct 2005 10:10] Valeriy Kravchuk
Thank you for a problem report. Please, describe the exact steps you performed for upgrade.

Have you read the appropriate parts of the manual, http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html and http://dev.mysql.com/doc/refman/5.0/en/upgrading-grant-tables.html?
[26 Oct 2005 12:46] Frank Büttner
Must I run the script after or before the update?
I have try it after but this will not work, becouse of the problem with the user rights.
[26 Oct 2005 13:10] Valeriy Kravchuk
You should install updated version to the same data directory, then perform the update script. What error messages do you get?

You still had not described all the steps yu performed to update, by the way.
[26 Oct 2005 13:26] Frank Büttner
first stop the server than update the packages via rpm -Fvh *.rpm.
Next modify the /etc/my.conf (remove the the entry basdir) then restart the server. And try to run the fix script. But this fails with the error wrong password or root@localhost has no right to connect.
[27 Oct 2005 1:21] Chris DiMartino
I also ran in to this problem.  The worlaround was to:

Install 5.0.15.
Migrate Data.
Start mysqld_safe with --skip-grant-tables option.  This disables all passwords/hostname lookups.  You should problably also add --skip-networking for safety reasons.
Run the fix grant table script now as root with no password.
Restart mysql with normal startup options.

After this, the grant tables should be in line with what is required.
[27 Oct 2005 8:30] Frank Büttner
Yes this works. But I think this must be in added to the  manual.