When you connect without specifing the host, the mysql client will try to connect using the mysql socket file (usually /tmp/mysql.sock or /var/lib/mysql/mysql.sock) and when you specify the IP address it will try to connect using a TCP connection to port 3306.
My guess is the you have name lookups turned on. If this is the case mysql will try to resolve the IP address given and probably the 192.168.3.111 IP is not resolving properly. The solution for this is to a add a skip-name-resolve option to your MySQL configuration file. You might also check http://dev.mysql.com/doc/refman/5.0/en/dns.html and the related articles in the MySQL documentation HTH Dobromir Velev On Thursday 13 October 2005 15:38, Anil wrote: > Hi List, > > > > When I am trying to connect to mysql 4.0.20 database it is taking very long > time when I specified host like > > > > Mysql -uxxxxx -p -h192.168.3.111 > > > > But it is connecting very quickly when I tried like below > > > > Mysql -uxxxxx -p > > > > > > It is an urgent issue. Please help me. > > > > Thanks > > Anil > > DBA -- Dobromir Velev -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
