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

[Ross Lazarus]

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')"""</interactive>

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...!!)

[Andy Dustman]

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.