warning message

[Fang]

Hi, I installed MySQL4.1.11 and PHP4.3.10. When trying to connect an existing
database, it showed me the following warning message which I have no idea how to
solve it. Hope someone can kindly tell me what I should do. Thanks in advance.
Warning: mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client in
c:\inetpub\wwwroot\project\connection.php on line 12
Could not connect: Client does not support authentication protocol requested by
server; consider upgrading MySQL client

[Andy Hassall]

On Mon, 2 May 2005 06:41:12 +0000 (UTC), " Fang" <s4******@student.uq.edu.au>
wrote:

Hi, I installed MySQL4.1.11 and PHP4.3.10. When trying to connect an existing
database, it showed me the following warning message which I have no idea how to
solve it. Hope someone can kindly tell me what I should do. Thanks in advance.

Warning: mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client in
c:\inetpub\wwwroot\project\connection.php on line 12
Could not connect: Client does not support authentication protocol requested by
server; consider upgrading MySQL client

Search on Google. The first hit for this error message is the explanation from
the MySQL manual. (Most of the other hits are people explaining this).

--
Andy Hassall / <an**@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

[coolsti]

On Mon, 02 May 2005 06:41:12 +0000, Fang wrote:

Hi, I installed MySQL4.1.11 and PHP4.3.10. When trying to connect an
existing database, it showed me the following warning message which I
have no idea how to solve it. Hope someone can kindly tell me what I
should do. Thanks in advance.
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
c:\inetpub\wwwroot\project\connection.php on line 12 Could not connect:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client

Hi,

I am sure the former reply with the google search says it all. But in case
you want a short explanation in the clear, it is because the newer mysql
versions use a stronger encryption than the older. But the functions
within PHP still are based on the older. So there is a mismatch here. You
won't be able to authenticate as the passwords won't seem to match, even
though the unencrypted versions are the same.

For now, to get around this, you request your mysql to use old passwords.
I am sure the Google search tells you how to do this exactly. If you look
at "show variables" in a mysql terminal, and see "old_passwords = on" or
whatever it is exactly, you should be ok. If off, you get the error you
are experiencing.