Bug #13781 refused connection on supposed lack of authentication support
Submitted: 5 Oct 2005 19:16 Modified: 5 Oct 2005 19:22
Reporter: Noel Taylor Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.13 OS:Linux (Linux)
Assigned to: MySQL Verification Team CPU Architecture:Any

[5 Oct 2005 19:16] Noel Taylor
Description:

I'm using python2.4.1 module MySQLdb to connect to MySQL server 5.0.13 which I just installed. Connections from a remote machine work fine when no password is required, but if a password is required, I get the following error when I try to connect:

   "Client does not support authentication protocol requested by server; consider upgrading MySQL client"

Everything I've read about this error assumes that the client is from a release below 4.1, but I can use the exact same teqchnique to make a successful connection with another MySQL server which is running MySQL v. 4.1.7. If it works for 4.1.7 it should work for 5.0.13, right? But it doesn't

For fun I tried restarting the server with the "old-passwords" option, but it made no difference.

How to repeat:
from an interactive python2.4.1 prompt:

>>>import MySQLdb
>>> db = MySQLdb.connect(db='blah', host='blah', user='blah', passwd='blah')
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/usr/lib/python2.4/site-packages/MySQLdb.py", line 458, in __init__
    self.db = apply(connect, (), kwargs)
_mysql.OperationalError: (1251, 'Client does not support authentication protocol requested by server; consider upgrading MySQL client')
[5 Oct 2005 19:22] MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.