MySQL Forums
Forum List  »  Install & Repo

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.

Options: ReplyQuote


Subject
Written By
Posted
December 31, 2005 12:02AM
December 31, 2005 02:28AM
March 29, 2006 03:12AM
March 24, 2007 02:58PM
January 03, 2006 07:48AM
March 16, 2006 10:03AM
November 02, 2005 07:38AM
January 16, 2006 03:46PM
July 24, 2006 07:40AM
March 28, 2006 11:18PM
August 23, 2006 01:21PM
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
October 08, 2006 10:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.