Hello.


Your server listens only on a single interface. Options could be given

in different ways, not only from configuration file. If you want

MySQL server to listen on every interface you should find where the

bind option is given and remove it. See:



  http://dev.mysql.com/doc/mysql/en/program-options.html





Andy McHargue <[EMAIL PROTECTED]> wrote:

> [-- text/plain, encoding 7bit, charset: us-ascii, 29 lines --]

> 

> I'm having trouble connecting remotely from Server A (local) to Server B 

> (remote).  Both Linux.

> 

> From Server A, I'm issuing this command

> mysql -h [domain.com] -u [user] -p

> 

> And I get

> ERROR 2003: Can't connect to MySQL server on 'domain.com' (110)

> I assume this is a time out.

> 

> 1. The user on Server B is set up with all privileges.

> 2. Server B's my.cnf has the line "bind-address=127.0.0.1" but it is 

> commented out with #

> 3. Server B's skip_networking is OFF.

> 4.  A netstat -tl on Server B gives the line

> tcp        0      0 domain.com:3306   *:*                         LISTEN

> 

> I notice that on a different server, I get this

> tcp        0      0 *:mysql                     

> *:*                         LISTEN

> 

> and there's no line containing 3306.

> 

> What's with that?

> 

> 5.  for troubleshooting's sake, ssh [remote-ip] -p 3306 times out.  

> telnet is unavailable.

> 

> 



-- 
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]

Reply via email to