Hello. Output of netstat shows that server is listening on all interfaces on 3306
port. Possible reason why you can't connect - the firewall protection. So at first you may try to telnet to 3306 port on that host from your machine and really check if tcp works. > I suddenly have lost the ability to connect to the MySQL server from my > remote host and can not figure out what is wrong. I have searched for > the last couple of days and cannot figure out why. > > > > I am running MySql 5.0.0 on Linux Suse 9.1 > > I normally connect to MySQL from Windows XP Pro using either the .Net > connector and/or the ODBC connector. >When I check the variables it shows that the port is set to 3306 >ut when I run the following it appears that TCP is not working >correctly. > >linux:~ # netstat -l | grep mysql > >tcp 0 0 *:mysql *:* >LISTEN > >unix 2 [ ACC ] STREAM LISTENING 4671 >/var/lib/mysql/mysql.sock > > > > If I log in via SSH or from a shell on the Linux box itself I can > connect to the database in any of the following ways: > mysql -u user_name -p database_name > > mysql -u user_name -p -h localhost database_name > > mysql -u user_name -p -h 127.0.0.1 database_name > > mysql -u user_name -p -h the_static_ip_address database_name >As soon as I try to connect from Windows XP using the .Net connector, >the ODBC connector, MySQL Query Browser or MySQL Administrator I get the >following error: > >Could not connect to the specified instance. >MySQL Error Nr. 2003 >Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10060) > > I am able to successfully ping the IP address of the Linux machine. >Here is what is listed in the /etc/my.cnf file > >[mysqld] >datadir=/var/lib/mysql >port=3306 >socket=/var/lib/mysql/mysql.sock > >[mysql.server] >basedir=/usr/bin > > >Any assistance is greatly appreciated. >>>>> "Doug Peters" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
