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:
- MySQL Command Line – Setting up a new database and user
- MySQL Backup & Restore
- MySQL 5.1 with DotNet claims Procedure or function ‘
‘ cannot be found in database ‘ ‘ - Move from BlogEngine.net to WordPress 2.7.1!
- The Path ‘/AppName/App_GlobalResources’ maps to a directory outside this application, which is not supported.
#1 by StokesyStokes on October 8, 2010 - 20:35
Hey Shaw – Hope it all goes well with your new job, you left many treasures behind like this, and I am feasting.
If I ever gave the impression I was anything less than awesomed by your knowledge then I apologise utterly.
All the best,
Richie
#2 by shawson on October 13, 2010 - 12:11
Mr Stokes!
Glad my blog still comes in handy! Thanks for your kind words! Hope everything’s going at the glamourous LBS offices and that my replacement is doing me justice! Don’t forget- if you ever get stuck with anything mental I’m only an email away!
Shawson