Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Posted by:
Terry James ()
Date: October 08, 2006 10:26AM
If someone hasn't said this already:
the mysql client is mysql
the mysql server [daemon] is mysqld
the first connects to the second that serves the application variables.
but your authentication protocol is something entirely different from both of them.
chap, md5, whatever, are authentication protocols. What the message is telling you is that you don't have the right handshake.
The best way to solve this is to get Ethereal and do a packet capture and read the auth dialects that are offered for the connection by the server.
It's in your operating system, the auth protocols, for basic connections, tcp/ip is what mysql should always connect on using a mutual encryption [hash like md5, chap, etc..] That setting is in your tcp/ip and operating system.