Make MySQL server available from not only localhost [solved]

pioneer-hg · n00b Joined: 29 Apr 2004 Posts: 27 Location: Kyiv, Ukraine

Hello everybody.

I have such situation. There are mysql server on my gentoo machine. It works well, but, I need to access it from another computer in the network, not only from this gentoo server. I permit access in mysql for user 'root' from any host (%) with all privileges and restarted mysql. But, it seems that mysql port is open only for localhost connections (according to the results of nmap scan from localhost and some other hosts within the network). So, I do not know what to do after that, advice me, please.

Oh, I forgot to say that there are iptables running on this server, but iptables rules are almost empty except two masquerade rules.
_________________
[pioneer]

adaptr · Posted: Thu Sep 15, 2005 12:41 pm Post subject:

Edit /etc/mysql/my.cnf and change the bind-address setting in the [mysqld] section:

pioneer-hg · n00b Joined: 29 Apr 2004 Posts: 27 Location: Kyiv, Ukraine

Thank you, it works!
_________________
[pioneer]

adaptr · Posted: Thu Sep 15, 2005 1:15 pm Post subject:

Errrm... yes ?

Of course it works.
_________________
>>> emerge (3 of 7) mcse/70-293 to /
Essential tools: gentoolkit eix profuse screen