MySQL on Debian 3.0: TCP listening

Hko · 09-03-2002, 04:33 PM

I installed MySQL (-server) on Debian 3.0.
'mysqladmin version' shows only a UNIX-socket the daemon is listening on.
How do I get it listening on a TCP-socket?

I tried commenting out the line "skip-networking" in /etc/mysql/my.cnf,
and I've also changed "safe_mysqld" to "mysqld" in /etc/init.d/mysql, and restarted it (even rebooted).

....but 'mysqladmin version' still doesn't report a listening TCP socket.
Anything more I could try? TIA

adam_boz · 09-03-2002, 07:57 PM

try "netstat -a | less" to see what's going on

Hko · 09-04-2002, 02:50 PM

I did.
There's nothing going on which has to anything to do with the MySQL server . :-(

adam_boz · 09-04-2002, 03:28 PM

I don't think that the netstat would return anything which has "MySQL" in the "Active Internet connections (servers and established)
" section I don't know what type of server that is, but look for the port number which it listens on in that section. ex: here's mine, i only have qmail running:

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 *:6000 *:* LISTEN
tcp 0 0 *:smtp *:* LISTEN

(that's just the relevant part to this topic, I think)
I'm sorry, I don't know where ells to direct you. I'm sure SOMBODY will be able to help though. Good Luck