Here's some more data on this, if anyone can help.
--I can connect the other way around ... i.e. I can connect from B to A. So there's no general connectivity problem.
--did an nmap on B,
$ nmap -sT -T Polite -p3306 xxxxxx.com
Starting nmap V. 2.54BETA22 ( www.insecure.org/nmap/ ) Interesting ports on s191.n33.xxxxxx.com (66.84.xx.xx): Port State Service 3306/tcp filtered mysql
nmap on B indicates 'open' rather than 'filtered' ... how can i change?
Andy McHargue wrote:
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.
-- Andy McHargue Webmaster Annenberg School for Communication University of Southern California http://annenberg.usc.edu [EMAIL PROTECTED] Phone: 213.740.1290
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
