Divi WordPress Theme

Client does not support authentication protocol MySQL error

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

Offline Kevin

  • Junior Guru
  • **
  • Posts: 69
  • iTrader: +4/-0
    • View Profile

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.

« 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.

Shopify Divi WordPress Theme

ClientX - WHMCS Client Area Theme

Started by aaronjonesBoard Marketplace

Replies: 0
Views: 3703
Last post August 28, 2018, 02:54:44 PM
by aaronjones
Fundamental questions every client should seek before selecting the VPS

Started by LucasChuaBoard Other Web Hosting Stuff

Replies: 0
Views: 580
Last post December 27, 2020, 08:30:31 PM
by LucasChua