Than you very much . It is working
Anil
DBA
-----Original Message-----
From: Dobromir Velev [mailto:dobromir@stripped]
Sent: Thursday, October 13, 2005 8:58 PM
To: mysql@stripped
Cc: Anil
Subject: Re: connection issue
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/mysql?unsub=1
