PDA

View Full Version : Fix for error 1251 after changing mysql 4.1.x password


mpx
03-06-2006, 12:39 PM
I had hardhat custom install mysql 4.1.x for me.

When I first went into PhpMyAdmin to change the root password, everything worked fine. I changed it, and then on relogin got this error:

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

This is a phpmyadmin bug I think. The fix is as follows:

Login into mysql on the command line:

mysql -u root -p

then:

set password for root@localhost = old_password('putnewpasswordhere');

and then exit mysql. phpmyadmin now works again!

This may be fixed in newer versions of Phpmyadmin. Dunno. Link to solution I found:

http://lists.mysql.com/mysql/179529