phpMyAdmin ... error #1251

r3a1 posted this at 22:10 — 10th January 2006.

Joined: Aug 2005

I'm working with setting up a developer's environment and I'm getting an error for which I can't find good documentation as to how to fix it ... that or I just don't understand exactly what is going on. From what I understand it has something to do with the new password hashing with sql however, all the threads I have read don't explain how to fix this error. Here is the environment I'm currently running.

PHP Version 4.4.1
MySQL: 4.1
(Client API version) 3.23.49
Apache: 2.0.55

everything is being accessed as a local host.

I would be happy to answer any other questions. Thanks so much in advance.

Ryan

-----------------------------------------------------
Welcome to phpMyAdmin 2.7.0-pl2

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error

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

------------------------------------------------------

r3a1 posted this at 22:44 — 10th January 2006.

He has: 28 posts

Joined: Aug 2005

So I tracked down the web guru at the local office and here is the answer to the my question. It has to do with the hashing algorithm that mysql uses (which is somewhat new) and the conflict with the verision of php I was using. you can revert the hashing of the password to the old algorithm with this command ran in your mysql command prompt. That will fix the problem or atleast it did in my case.

SET PASSWORD FOR 'zoooz'@'some_host' = OLD_PASSWORD('mypass');