Troubleshooting of mysql odbc configuration errors

"Client does not support authentication protocol requested by server "?

"Client does not support authentication protocol requested by server" is displayed when you install MySQL or a later version ".

Mysql 4.1 and later versions use the new password algorithm, while PHP does not support the new algorithm. Therefore, after a new user is added, you must use the following method to solve the problem that PHP cannot connect to Mysql: (some_user, some_host, and newpwd are the user name, host, and password of your database respectively)

Solution 1:

Mysql> SET PASSWORD

-> 'Some _ user' @ 'some _ host' = OLD_PASSWORD ('newpwd ');

For example, the database user is admin, the host is localhost, And the password is 123456.

At this time, the input command should be:

Mysql> set password for admin @ localhost = OLD_PASSWORD ('20140901 ');

Solution 2:

Mysql> UPDATE mysql. user SET Password = OLD_PASSWORD ('newpwd ')

-> WHERE Host = 'some _ host' AND User = 'some _ user ';

Mysql> flush privileges;

Solution 3 (not recommended)

Use the -- old-passwords option to enable mysqld, and then use the following method to change the original user