Connecting to MySQL

In my php script, I have written the following to connect to the database:

mysql_connect("localhost",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

I am trying to use a HTML form to insert records into the database. But, I am getting the following error:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in

I searched the net for this, I came across this page:
http://dev.mysql.com/doc/mysql/en/old-client.html

I tried the above things (but not sure, if I followed the instructions correctly) Still, I am not able to connect to the database.

Can you please explain me what is happening? Thanks for helping in advance.

Net Addict

 

You are not storing the mysql resource ID from connect and using it in your select.

http://us3.php.net/manual/en/function.mysql-connect.php

 

I don't think this is the problem. I think the problem is of different version of MySQL (and the way it interprets the password).

Cauz on my other host, with an older version of MySQL, I am using same commands without any trouble.

 

Although it's not a good practice, this is valid syntax (the last connection is used).

I've seen this error when I upgraded my MySQL server to 4.1.x from an earlier version.

J.D.

 

So, any solution?

 

I had this problem with my Win2K3 client and all I had to do is to download the latest ODBC driver. With PHP, I built all three (i.e. MySQL client/server and PHP) from the source and they all work together just fine. You can check the version of the server by running "select version();", but don't know how to check the version of the MySQL client built into PHP.

J.D.