Hi!
For some strange reason MySQL doesn't listen for incoming connections on port 3306. I have four servers, two of which are 4.0.1 and two are 3.23.47. I can connect between three of them freely, but one, shodan (yes. *g*) doesn't allow it. localhost logins are apparently ok, but not from another machine. [mle@hal9000 mle]$ mysql -uroot -p -hshodan Enter password: ERROR 2003: Can't connect to MySQL server on 'shodan' (111) perror says the following : "Error code 111: Connection refused". Checking netstat on shodan gives the following : mle@shodan:/$ sudo netstat --ip -p -a Active Internet connections (w/o servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 localhost:ldap localhost:1081 ESTABLISHED 649/stunnel [snip away truckloads of stunnels and other stuff] I just can't figure out why mysql doesn't show up. Here's the netstat --ip -a output on hal9000 : Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 *:mysql *:* LISTEN tcp 0 0 *:ssh *:* LISTEN [snip] and if I throw in a -p, too, we clearly see that MySQL is listening. tcp 0 0 *:mysql *:* LISTEN 3079/mysqld-max Summa summarum : For one reason or the other, the MySQL server on shodan doesn't accept incoming connections. hal9000 accepts them, xerxes accepts them and skynet accepts them, but not shodan. Shodan and skynet are identical machines, with debian 2.2 apt-get dist-upgraded once and I just plainly apt-got (*g*) mysql from a mirror. The configurationfiles are just about identical on the two machines. Ideas? Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
