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\wwwr oot\project\con nection.php on line 12
Could not connect: Client does not support authentication protocol requested by
server; consider upgrading MySQL client

[Andy Hassall]

Re: warning message

On Mon, 2 May 2005 06:41:12 +0000 (UTC), " Fang" <s4041650@stude nt.uq.edu.au>
wrote:
[color=blue]
>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\www root\project\co nnection.php on line 12
>Could not connect: Client does not support authentication protocol requested by
>server; consider upgrading MySQL client[/color]

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 / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
<http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool

[coolsti]

Re: warning message

On Mon, 02 May 2005 06:41:12 +0000, Fang wrote:
[color=blue]
> 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\wwwr oot\project\con nection.php on line 12 Could not connect:
> Client does not support authentication protocol requested by server;
> consider upgrading MySQL client[/color]

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_passwo rds = on" or
whatever it is exactly, you should be ok. If off, you get the error you
are experiencing.