Divi WordPress Theme

Topic: Client does not support authentication protocol MySQL error  (Read 4495 times)

Offline Kevin

  • Junior Guru
  • **
  • Posts: 72
  • iTrader: +4/-0
    • View Profile
Hi,

You might have seen the error "Client does not support authentication protocol" in your application. This is due to version problem of MySQL.  For example, if you upgrade your server from MySQL 4.0 to MySQL 4.1 then you may face the problem to connect to your MySQL Database. You may receive the below error:

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

To solve this problem, you can follow the below option:

- Go to command prompt of mysql using below command:
mysql -u root -p

- Then shot out the below command:

UPDATE mysql.user SET password=OLD_PASSWORD('somepassword')
WHERE user='someuser' AND host='somehost';

- Now flush the privileges using the below command:

flush privileges;

You are facing this problem because both the versions of MySQL use different format to store password.

Kevin
« Last Edit: January 01, 1970, 05:30:00 AM by Kevin »
VPS Hosting - AccuWebHosting

Offline scott

  • New Member
  • *
  • Posts: 33
  • iTrader: +0/-0
    • View Profile
Re: Client does not support authentication protocol MySQL error
« Reply #1 on: September 14, 2008, 06:53:07 PM »
Hi Kevin,

Thanks for sharing it.

Scott
Shopify Divi WordPress Theme
Tags: