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]
