Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#116 fix for old-authentication problem for mysql 4.1+

MySQLdb-1.0
closed
Andy Dustman
MySQLdb (285)
1
2012-09-19
2004-12-04
Ross Lazarus
No

The readme says that mysql 4.0 is supported, but here's
a heads up just in case anyone tries to connect to 4.1
or 4.2 like I just did (you can, but not without a
little futzing).

According to
http://dev.mysql.com/doc/mysql/en/Old_client.html
MySQL versions 4.1+ have a new authentication algorithm
- so trying to connect from the command line with
MySQLdb 1.0 I got
"""File "<interactive input="">", line 1, in ?
File
"C:\Python23\lib\site-packages\MySQLdb__init.py",
line 64, in Connect
return apply(Connection, args, kwargs)
File
"C:\Python23\lib\site-packages\MySQLdb\connections.py",
line 116, in
init
self._make_connection(args, kwargs2)
File
"C:\Python23\lib\site-packages\MySQLdb\connections.py",
line 41, in _make_connection
apply(super(ConnectionBase, self).
init__, args,
kwargs)
OperationalError: (1251, 'Client does not support
authentication protocol requested by server; consider
upgrading MySQL client')"""

I made a new user and set their password to the
old-authentication hash using the instructions on
http://dev.mysql.com/doc/mysql/en/Old_client.html and I
could then connect. I hope this is useful for others
encountering this (by ignoring the explicit warning
that only 4.0 is currently supported...!!)

Discussion

  • Andy Dustman
    Andy Dustman
    2004-12-28

    Logged In: YES
    user_id=71372

    Not a MySQLdb bug, but I will leave open for people looking
    for a solution to the 4.0 client -> 4.1 server issue.