enable external mysql connection on :3306

[sascha]

hi,

i use ispmanager pro. how can i enable connections to mysql port 3306 to connect to the db with external programms?

thx
sascha

[slava]

You need enable "Allow remote access" checkbox in the database user properties.

[sascha]

ok, i´ve enabled it, but still


PORT STATE SERVICE
3306/tcp closed mysql

i've restart the server, but nothing changes

thx

[slava]

By default MySQL listen all this port. Possible firewall or internet provider blocked this.
What's show command
netstat -na | grep 3306
?

[sascha]

the firewall is off.

ispmanager:~# netstat -na | grep 3306
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN

[sascha]

i am confused :) look this:

ispmanager:~# nmap localhost -p3306

Starting Nmap 4.62 ( http://nmap.org ) at 2009-12-01 19:45 CET
Interesting ports on localhost (127.0.0.1):
PORT STATE SERVICE
3306/tcp open mysql

********

ispmanager:~# nmap 80.XXX.XXX.XXX -p3306

Starting Nmap 4.62 ( http://nmap.org ) at 2009-12-01 19:45 CET
Interesting ports on dedicaXXXXXXXXXXXXXXXXX
PORT STATE SERVICE
3306/tcp closed mysql

both scans are from the server itself. when is use its server own ip, the port is closed, if i used loacalhost, everything is ok??

my firewall is of, and the provider has no firewall !

greets
sascha

[sascha]

no idea? from anyone?

[tanya]

Hi,

You should delete the string "bind-address =" from the file /etc/my.cnf

[sascha]

thats it, thx :)