fix for old-authentication problem for mysql 4.1+
MySQL database connector for Python programming
Brought to you by:
adustman
Menu
▾
▴
#116 fix for old-authentication problem for mysql 4.1+
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...!!)
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.