Page 2 of 2

Posted: Wed Aug 04, 2004 10:39 am
by nigma
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.

Posted: Wed Aug 04, 2004 9:14 pm
by mmaru
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:

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));

?>
Hope you can help me.

Posted: Wed Aug 04, 2004 9:37 pm
by mmaru
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.

Posted: Wed Aug 04, 2004 9:38 pm
by nigma
Don't know anything for sure, I'd try to updating to a newer version of mysql, unless someone else posts different advice.