Since your using php5 you need to configure php to use the mysql extension.
Check out php.net for information on how to do that.
MySQL connection problem
Moderator: General Moderators
I had to do some research on how to configure PHP 5 and MySQL on Windows 2000. It was a good learning experience. I am now getting the following error message:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
The code that generated the error message is:
Hope you can help me.
Client does not support authentication protocol requested by server; consider upgrading MySQL client
The code that generated the error message is:
Code: Select all
<?php
mysql_connect('localhost','mmaru','marumysql') or die(mysql_error());
$query = mysql_query('SELECT VERSION()') or die(mysql_error());
print_r(mysql_fetch_row($query));
?>Yes it is working fine. A good learning experience. The answer to the error message is in the MySQL manual.
A.2.3 Client does not support authentication protocol
MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to it with an older client may fail with the following message:
shell> mysql
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
To solve this problem, you should use one of the following approaches:
* Upgrade all client programs to use a 4.1.1 or newer client library.
* When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password.
* Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Thank you very much all of you and happy computing and community.
A.2.3 Client does not support authentication protocol
MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to it with an older client may fail with the following message:
shell> mysql
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
To solve this problem, you should use one of the following approaches:
* Upgrade all client programs to use a 4.1.1 or newer client library.
* When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password.
* Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Thank you very much all of you and happy computing and community.