MySQL password issue through phpmyadmin after upgrade

kiss-o-matic · Guru Joined: 19 Jul 2004 Posts: 423 Location: Tokyo

Summed up version:

-Upgraded from some old version (4.X I think) to 5.0 months ago
-Never touched it until today
-mysqld won't start due to "[ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format." error
-Ran solution found here

After running that, none of my passwords worked. MySQL would start, but it seemed to not be reading mysql.users databsae correctly. I started mysqld in safe mode, and manually reset the passwords as found near the bottom of this page.

I can login using 'mysql -u user -p' now, w/ the password I've set above. However, this password does not work via phpmyadmin. I restarted apache2 just to make sure, but as expected, that did nothing.

elgato319 · Guru Joined: 15 Sep 2005 Posts: 546

What is your auth_type in config.inc.php?

?

magic919 · Posted: Tue Apr 17, 2007 6:02 pm Post subject:

Things change. Have a look here

http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html

Might help.