I recently installed mysql 5 under Windows 2003, with phpMyAdmin running under IIS 6 and came across an issue trying to get phpMyAdmin to access the database- I found that the root credentials were’nt accepted. The error i receive was
“#1251 – Client does not support authentication protocol requested by server; consider upgrading MySQL client”
Apparently this is to do with me using an older version of phpMyAdmin and how the passwords are encrypted- I found an article on WebMasterWorld detailing how to resolve it;
Login from the command line to your MySQL database;
mysql -u root -h localhost -p
- -u lets you set the username to use, in this case I’m using the root account
- -h sets the host- I’m logging in from the local machine so used localhost- I havn’t enabled root access from any remote machines
- -p indicates that you will be supplying a password
You will then be prompted the enter the password for your database. Once you’re in, execute the following sql to update the password
UPDATE mysql.user
SET password=OLD_PASSWORD('somepassword')
WHERE user='someuser';
AND host='somehost';
Once that’s done you will also want to flush the priviledges;
flush privileges;
You can now safely quit the mysql client with ‘exit’ and you are set!
This is also covered on the mySQL documentation site.
Related posts:
