Closed (fixed)
Project:
Drupal core
Version:
5.4
Component:
other
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
21 Aug 2008 at 00:25 UTC
Updated:
12 Dec 2008 at 15:22 UTC
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
Comment #1
andrewblack commentedwhen 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..
Comment #2
alex commentedShould 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.
Comment #3
andrewblack commentedsorry 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
Comment #4
ainigma32 commentedJudging 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