database connect error can someone help please?

I was just trying to make a simple connection to a local dadabase from a php
file.

Could not connect: Client does not support authentication protocol requested
by server; consider upgrading MySQL clientPHP Warning: mysql_connect():
Client does not support authentication protocol requested by server;
consider upgrading MySQL client in C:\Program Files\Apache
Group\Apache2\htdocs\testing\_debug_tmp.php on line 2 PHP Warning:
mysql_select_db(): supplied argument is not a valid MySQL-Link resource in
C:\Program Files\Apache Group\Apache2\htdocs\testing\_debug_tmp.php on line
3

On Sat, 19 Mar 2005 21:09:05 -0700, "David Woodard"
<davidinwinslow@cableone.net> wrote:

> Could not connect: Client does not support authentication
> protocol requested by server; consider upgrading MySQL
> clientPHP

It means what it says: The MySQL client in PHP does not
support the authentication method that is required by newer
versions of MySQL server.

> Warning: mysql_connect(): Client does not support
> authentication protocol requested by server; consider
> upgrading MySQL client in C:\Program Files\Apache
> Group\Apache2\htdocs\testing\_debug_tmp.php on line 2

Possible solutions:
- install a version of PHP of which the MySQL client
library supports the authentication method of your
MySQL server version
- use an old version of MySQL server
- start the MySQL server with some option to force
it to use the old authentication method.
- trick the password column in the MySQL system
database (mysql)

Read the PHP and MySQL documentation (especially the
release notes) for more details.

> PHP Warning: mysql_select_db(): supplied argument is not a
> valid MySQL-Link resource in C:\Program Files\Apache
> Group\Apache2\htdocs\testing\_debug_tmp.php on line 3

This is of course the result of the previous error.

BTW: comp.lang.php is more appropriate for php and mysql
questions, so I set FUP to that group.

Good luck.

--
) Kees Nuyt
(
c[_]