Client does not support authentication protocol requested
| From: | Khalid Judeh | Date: | Mon, 22 Mar 2004 12:28:09 +0000 |
| Subject: | Client does not support authentication protocol requested | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-181130@lists.php.net to get a copy of this message | ||
i psoted a message here before few days asking how to solve this problem, fortunately i found the
solution on a website, i reseted the pass and all worked.
MySQL 4.1 uses an authentication protocal based on a password hashing algorithm that is incompatible
with that used by older clients. If you upgrade the server to 4.1, attempts to connect to a it with
an older client may fail with the following message:
shell> mysql
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
To solve this problem you should do one of the following:
Upgrade all client programs to use the 4.1.1 or newer client library.
Use a user account with an old password when connecting from a pre 4.1 client.
Reset the user that needs a pre-4.1 client to use an old password:
mysql> UPDATE user SET Password = OLD_PASSWORD('mypass')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
Tell the server to use the older password hashing algorithm:
Start mysqld with --old-passwords.
Set the password for all users that has a long password. You can find these users with:
SELECT * FROM mysql.user WHERE LEN(password) > 16;
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.