Problem and solution of: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client
Background: Just upgrade from MySQL 4.0 to Mysql 5.0. First stop the MySQL 4 services > run the MySQL 5 installer > Rename the services name from 'Mysql' to 'Mysql5' if you have the problem that the mysql services name is conflicted. After that, using PHP 4.3.3 > use mysql_connect to connect to this server > the above problem exist. Problem: Error: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client" Solution:This is the problem of old_password in Mysql 4. In short, after upgrading to mysql 5, the encryption method of user's password is different from mysql 4. If you CREATE A USER IN MYSQL 5, since the password encryptio method will be different from mysql 4, even if the username and password are exactly the same, you cannot connect to this brand new mysql 5 server. To solve: I use Mysql administrator provided and freely download from www.mysql.com. Login to database FROM L...