Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- warning message
May 2, 2005, 6:41 am
rate this thread
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
Re: warning message
On Mon, 02 May 2005 06:41:12 +0000, Fang wrote:
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
- » Last rites declaration of Ioannes Paulus PP. II (Karol Wojtyla)
- — Previous thread in » PHP Scripting Forum