MySQL Forums
Forum List  »  Install & Repo

Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Posted by: Bill Karwin
Date: October 10, 2006 06:19PM

This doesn't make any sense. In my experience, this error only occurs when the MySQL Server is >=4.1, and the client is <=4.0. Are you absolutely certain you are not connecting to another instance of MySQL Server on this host or another host?

Regardless of what RPM says is installed, the actual files may be different if someone has upgraded them. Or there could be a separate instance of MySQL under a different directory, which is the actual one running, and the instance supplied by the RPM could be idle. Find out the version of mysqld by running "mysqld --version". Make sure you're invoking the binary that is actually run by the service init script, in case it's not the same binary that was supplied in the RPM. "find / -name mysqld" might be in order.

As for the my.ini/my.cnf issue... right, by default there may be no such file on your system. The absence of the file means that only defaults are used. Note that the "old_passwords" option should be placed in a group within the file under a "[mysqld]" heading. See http://dev.mysql.com/doc/refman/4.1/en/option-files.html for information on the location(s) of my.cnf, and the options group notation.

Regards,
Bill K.

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