• Welcome to Web Hosting Community Forum for Webmasters - Web hosting Forum.
 

Recommended Providers

Fully Managed WordPress Hosting
lc_banner_leadgen_3
Fully Managed WordPress Hosting

WordPress Theme

Divi WordPress Theme
WPZOOM

Forum Membership

Forum Membership

Client does not support authentication protocol MySQL error

Started by Kevin, July 03, 2008, 02:23:07 AM

Kevin

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

scott