By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,405 Members | 1,579 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,405 IT Pros & Developers. It's quick & easy.

warning message

P: n/a
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
Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Jul 17 '05 #2

P: n/a
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.

Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.