Hi, Does the 10.4.0.101 reverse resolve to a specific hostname? If it does you are probably running MySQL with the skip_hostname_resolve option and if it doesn't there is no way the MySQL server could tell from which host the request is comming.
My opinion is that it is always better to use the IP-addresses instead of the hostnames and use skip_hostname_resolve - the connection overhead will be smaller this way. You can also check the comments on http://dev.mysql.com/doc/mysql/en/dns.html -- Dobromir Velev [EMAIL PROTECTED] http://www.websitepulse.com/ On Friday 02 September 2005 13:38, T. Horsnell wrote: > After replacing a 3.23.28 server with 4.1.14 server binaries on an Alpha > running Tru64 5.1B, I get things like: > > ERROR 1045 (28000): Access denied for user 'tsh'@'10.4.0.101' (using > password: YES) > > when trying to connect from a remote host. > > The problem goes away if I replace hostnames by IP addresses > in the mysql 'user' tables. I see from the archives that this > problem has been reported recently by others. Is there a fix? > (apart from changing every relevant entry in the user tables) > I cant see anything relevant in the Buglists. > > > Cheers, > Terry. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
