MySQL 5 / phpMyAdmin Installation – root account not accepted


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.

  1. #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. #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

(will not be published)


I absolutely love these. They came at the lace wigs are good quality, and very soft. Absolutely love these extensions. I just love this hair. Hair came on time, I waited until after hair extensions uk very full, no shedding and it is been installed for 3 weeks now and yes I jus ordered 3 more bundles. Lol. I definitely recommend this company for your bundles ladies. They are soft, hair bundles on the head for human hair wigs and I would continue to recommend them. I have thinner hair so they cover and blend nicely.