Renán, > I installed the version 4.1.0-alpha of mysql in > Windows XP. At the beginning and in general everything > works very well. But I have a problem of > incompatibility (I guess). When users are created with > passwords, those users cannot be connected. Mysql > says: "Client don't support the authentication > protocol required by server, consider upgrade client". > What happen ????
The length of the password hash (in the mysql.user Password column) has changed from 16 (MySQL < 4.1.0) to 45 bytes (MySQL 4.1.0). You can still use the old hash length, but this is sort of tricky, and documentation about this is about to be released in the near future. Unfortunately, there will be yet another change regarding the Password column in 4.1.1 that makes documentation of that behaviour a bit more complicated. Anyway, what you describe above is a typical problem that arises when you create a new user (with GRANT) or change an existing user's password (e.g. with SET PASSWORD), and then try to connect as that user with an older client (e.g. mysql from 4.0.13). Trying to connect as that user from a new client should be no problem. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
