#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client.?

Question

I have MYSQL 5.0 I never had mysql 4.0 Ihad my 4.1 somehign.



what do i do/ please give me STEP by step help

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql
-u root -p butter
> set password for 'root'@'localhost' =
old_password('bu' at line 1


wtF?!?!?

Answer 1

This generally happens when you use an old client with a new server. The easiest workaround is to change the password for the account by using old_password. There is a bit of a chicken and egg problem, however. In order to change the password you need to be able to log on to mysql. Assuming you have command line access, you can do something like:

(replace username and password with your real user name and password)
mysql -u username -ppassword
> set password for 'username'@'localhost' = old_password('password');
> flush privileges;
> quit

Depending upon your usage you may need to do this for additional hosts (each username@hostname has its own password). It is sometimes easier to do:
update mysql.user set password = old_password('password') where user = 'username';
flush privileges;

Answer 2

i assum this is in something like php. You need to upgrade your client library. Go to the mysql site, find the language you are using, and download the latest connection library and follow the instructions on how to install