I'm running a Slackware box (Linux 2.6.21.5-smp) with "mysql 5.0.51 for slackware-linux-gnu".
I…
1. have no iptables rules at all, and the three chains are indeed
ACCEPT;
2. have the "
skip-networking"
commented out in
/etc/my.cnf;
3. do have a port specified in
/etc/my.cnf (i.e., it's not blank or commented out);
3. can connect locally (presumably via the socket)
4. cannot connect remotely
Furthermore, port-scanning (with nmap), even from localhost, reveals that 3306 is closed.
In case someone is considering this, I do indeed also have a user with privileges from the remote (LAN, DNS-resolvable) host from which I am attempting to connect.
I have rechecked
/etc/my.cnf and
/etc/rc.d/rc.mysqld restarted just to be on the safe side. I even rebooted the whole server (first time in almost a year!)
I noticed the following set of recurring lines in
/var/lib/mysql/<hostname>.err, however:
Code:
Version: '5.0.51-log' socket: '/var/run/mysql/mysql.sock' port: 0 Source distribution
Why is 3306 closed? It looks like mysql isn't even trying to start networking…
3306 closed, even though it shouldn't be?
