Re: mysql-direct authentication lossage

[i'm resending this reply to the whole mailing list]




 The mysql folks enhanced the authentication mechanism and
altered the wire protocol incompatibly in version 4.1 
(or maybe it's 4.11 as Kuroda has noted). 
 
 I've made changes to the mysql interface code to talk the new
authentication protocol but haven't finished work on the
new wire protocol.

 There is a way to for mysql clients that know only the pre-4.1
protocol to communicate with a 4.1 or later mysql server: 
set the password of the account to an older, smaller, password.
The mysql manual shows you how.    If you have a small password
then the mysql server will talk the old protocol.


 Here's a part of the mysql.user table from my test server.  Note that 
there is only one account with a long password thus that's the only
one I can *not* connect to using the current acl mysql interface
  
 
mysql> select user,password from mysql.user;
+------+-------------------------------------------+
| user | password                                  |
+------+-------------------------------------------+
| root | 67457e226a1a15bd                          |
| root |                                           |
|      |                                           |
|      |                                           |
| jkf  | 7b4a7bd528886d1a                          |
| root | 67457e226a1a15bd                          |
| jkf  | *25C7DCAE00E1A5AAF233D811490E1776EEEF550C |
+------+-------------------------------------------+
7 rows in set (0.00 sec)