enable external mysql connection on :3306
hi,
i use ispmanager pro. how can i enable connections to mysql port 3306 to connect to the db with external programms? thx sascha |
You need enable "Allow remote access" checkbox in the database user properties.
|
ok, i´ve enabled it, but still
PORT STATE SERVICE 3306/tcp closed mysql i've restart the server, but nothing changes thx |
By default MySQL listen all this port. Possible firewall or internet provider blocked this.
What's show command Code:
netstat -na | grep 3306 |
the firewall is off.
ispmanager:~# netstat -na | grep 3306 tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN |
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 |
no idea? from anyone?
|
Hi,
You should delete the string "bind-address =" from the file /etc/my.cnf |
thats it :)
thats it, thx :)
|
All times are GMT +2. The time now is 03:24 PM. |
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.