"MySQL Server Error (1251)" Solution

Although MySQL 4.1.7 has been released and has become an official recommendation version, the 4.0.x series has not stopped updates and bug fixes. In fact, most MySQL versions on the server are 3.x.

After MySQL is updated to version 4.1.17, it is found that you need to use the MySQLi extension to use the database normally. Otherwise, the 1251-Client does not support authentication protocol requested by server will appear; consider upgrading MySQL client prompt, this is very puzzled, I did not study the specific problem, just switch to MySQLi extension, in fact, you can still use MySQL extension before adding a password to the root, however, after adding a password to the root user, the above Client Version is too low.

Currently known solutions:

Log on to the MYSQL server as the root user and run

Mysql> set password for user1 @ "localhost" = old_password (yourPassword );

The reason is that the new password verification mechanism is used in the mysql server version you are using. This requires the client version to be later than 4.0. The original password function is changed to old_password ();, in this way, it is difficult to use the password () generated by the client in the old version, while the MYSQL client in PHP is 3.23 (except for mysqli extension ), this is the problem.

Update information: ChangeLog

Download: html "target = _ blank> http://dev.mysql.com/downloads/mysql/4.0.html

Link to this article:
Http://www.openphp.cn/index.php? Module = article & id = 132