MySQL auth errors...
Cant find any info on this... I think i know what is causing the error, but other db plugins work :S
So.. i've got mysql 4.1.x.. and when i try to: Code:
new Sql:g_sql;Code:
L 10/22/2005 - 19:16:19: [MYSQL] DB Connection failed(1251): Client does not support authentication protocol requested by server; consider upgrading MySQL client |
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
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. * When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password. * 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; 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. |
ok thanks. it works...
-- GeekFOrce |
| All times are GMT -4. The time now is 23:37. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.