MySQL Bugs: #13781: refused connection on supposed lack of authentication support

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

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')

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.