My hosting database said error like this.. i don't change any thing in script. How can i repair that?

The MySQL error was: Client does not support authentication protocol requested by server; consider upgrading MySQL client.

Thanks

Comments

andrewblack’s picture

when i search in mysql.com there are alternative

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

To solve this problem, you should use one of the following approaches:

* Upgrade all client programs to use a 4.1.1 or newer client library. (already now i using MySQL version 4.1.22-standard)
* When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password. (i don't know that meaning ;( )
* Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

Alternatively, use UPDATE and FLUSH PRIVILEGES:

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES; (i don't know that meaning ;( )

Substitute the password you want to use for “newpwd” in the preceding examples. MySQL cannot tell you what the original password was, so you'll need to pick a new one.

please help..

alex’s picture

Should be probably posted in http://drupal.org/forum/1

It doesn't have anything to do with drupal, it's your server or host configuration. MySQL client in your case is a library used by PHP wich is incompatible with your mysql version. If you are developing on your own localhost or server, try upgrading php, otherwise ask your hoster to help. The quick fix with OLD_PASSWORD() could help too.

P.S. Your software is really outdated. I haven't seen one of those errors in years.

andrewblack’s picture

Version: 5.5 » 5.4

sorry about mis-thread..

sorry for newbie ask..how can i implemntation about "The quick fix with OLD_PASSWORD() could help too."?

thanks
sorry for mess

ainigma32’s picture

Status: Active » Fixed

Judging from the track this solved some time ago so I'm setting this to fixed.

Feel free to reopen if you think that is wrong.

- Arie

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.