Wes, I don't think this is the issue as my passwords are all still in the old format. Plus, the 4.0.16 client has no problem connecting.
Thanks -keith >Keith: >I don't know if it's the same problem, but I recently had issues where >I had a similar setup with only two MySQL servers, one 4.0.20, the >other 4.1.3, same usernames/passwords on each. >My solution, and I don't remember where in the manual I saw this >(possibly the FAQ), was to do an update to the 4.1.3 mysql user table: >UPDATE user SET Password = OLD_PASSWORD( Password ) WHERE ... <fill in >with username/host/whatever> >I believe this was because I was trying to connect to MySQL 4.1.x with >a 4.0.x client. I don't know if that's your case as well. >http://dev.mysql.com/doc/mysql/en/Old_client.html >Wes >On Jul 28, 2004, at 6:21 PM, Keith Thompson wrote: >> I have a mysql connection problem that I'm trying to understand. >> >> The three servers and the version of mysql they are running (all under >> Solaris9) are: >> db1 - 4.0.16 >> db2 - 4.0.17 >> db3 - 4.1.3 >> >> All three systems have the same mysql user and passwords setup. I'll >> use the mythical user "xx" with password "yy" to explain here. >> Connections with the mysql client (using "-uxx -pyy") from system to >> system all work except this one on db2: >> >> mysql -hdb3 -uxx -pyy >> ERROR 1045: Access denied for user 'xx'@'db2' (using password: YES) >> >> The mysql.user table entry has host=% and user=xx, so it's not simply >> an issue of a system-specific entry allowing one and not the other. >> Since >> db1 has no problem getting to db3, I wouldn't expect db2 to struggle. >> This same problem occurs with all users, so it' is also not something >> specific to how this user is setup. >> >> Does anyone know why this would be happening? >> >> Is there something different in 4.0.17 (compared to 4.0.16) that >> prevents >> it from connecting to the 4.1.3 server? I don't see anything in the >> 4.0.17 change list specific to this. >> >> Thanks -keith >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> >> >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
