[EMAIL PROTECTED] wrote on 06/21/2005 01:56:50 PM: > Hi everyone, > Trying to connect to a MySQL database from a Linux Server using PERL > to a Windows Machine with a MySQL database (5.0.6). I can connect > successfully on the windows box but cannot on the Linux server! I > ran a SQLTRACE (DBD) with the following output: > imp_dbh->connect: dsn = database=userdb:hostname=192.168.2.113: > port=3307, uid = user1, pwd = user1 > imp_dbh->MyLogin: dbname = userdb, uid = user1, pwd = user1,host = > 192.168.2.113, port = 3307 > imp_dbh->mysql_dr_connect: host = 192.168.2.113, port = 3307, uid = > user1, pwd = user1 > imp_dbh->mysql_dr_connect: client_flags = 2 > imp_dbh->mysql_dr_connect: <-Access denied for user 'user1'@'192. > 168.3.90' (using password: YES) error 1045 recorded: Access denied > for user 'MSA'@'192.168.3.90' (using password: YES)
> > What disturbs me is that the return error comes back with a > different IP address than what I sent out. Anyone have any idea as > to why? That would seem to be the problem with the "access denied"! > George The IP address in your error message (192.168.3.90) is not the address you are trying to reach (your server's address) but the address of where you are calling from (your client's address). Authentication depends on not just WHO you are (as a MySQL user) but also from where you are trying to connect. Check for an entry in the mysql.user table that allows that user account to connect from that address. If all it has is an entry for that user to connect from the host "localhost", that would be your problem. http://dev.mysql.com/doc/mysql/en/privilege-system.html You may also be running into a password hashing issue. Some clients (that term includes programming APIs) do not know how to authenticate against the stronger, longer password hash introduced in v4.1. More details and at least 3 workarounds here: http://dev.mysql.com/doc/mysql/en/old-client.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
