Login ID Password Forgot Password?
Custom Search
Poll
What's your favorite browser?
Internet Explorer
FireFox
Netscape
Opera
 
 

Blog

MySQL Error (1250) : Client does not support authentication protocol
by Louie Y K Wong (Posted: 30/7/2009 07:46 PM)

Since MySQL had evolved into a common tool being used by the majority groups of web application developer as an open source database and version 4.1.x or above released, a kind of hashing basis algorithm for authentication protocol which is no longer supports the client-side of old version MySQL. While the client-side makes a request of password authentication from MySQL server-side, due to the algorithm of both sides are not identical, the following error consequently occurs:

Error (1250) : Client does not support authentication protocol requested by server; consider upgrading MySQL client

If upgrading work is tedious to you or you are very reluctant to recompile the MySQL Client library, here you have the altenative solution, namely revoking SET PASSWORD and OLD_PASSWORD() function to reset the password and make it compatible with MySQL version 4.1.x or higher.

login to MySQL,

# mysql -u root -p
Enter password:

Welcome to the MySQL monitor.  Commands end with ; org.
mysql>UPDATE mysql.user SET password=OLD_PASSWORD('yourpasswd') WHERE user='root' AND host='localhost';

Query OK, 1 row affected (0.07 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql>flush privileges;
Query OK, 0 rows affected (0.04 sec)
 
View: 1761 | Comment: 0 | This Blogger only | All Bloggers
Comment this post?

0 Comment(s)
Our CMS is powered with