Posts

Showing posts from September, 2006

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

How to remove symbolic link in Linux

Syntax: unlink

How to install BerkeleyDB without perl -MCPAN -e shell?

Using: yum -y install perl-BerkeleyDB insteed.