MySQL Forums
Forum List  »  Install & Repo

Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Posted by: Peter Flynn
Date: October 10, 2006 06:29AM

Unfortunately it's not pebkac (that would be way too easy :-)

The error message "ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client" has a major defect in that it fails to identify *what* protocol was being used that failed. In addition, I get this running the matched pair of RPMs for 4.0.21-0, so it is not meaningful for the error message to suggest that upgrading the client will solve the problem.

At the moment, neither mysqladmin nor the mysql command will allow my user to login as root, because root's password was changed, and since then all they get is this error message.

Might I make the suggestion that the error message be reworded to say what is actually at fault (MySQL has lost track of something) and specify the protocol that failed. This would at least allow users to start tracing the error, for which no solution exists at the moment (that is, none of the suggestions posted to date addresses the problem).

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
Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
October 10, 2006 06:29AM
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


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.