tcp - Connection to remote mysql server not working even with bind-address, privileges and ip tables configured -


so i've been trying connect remotely mysql server can't work. here's did.

i set bind-address=0.0.0.0 able connect anywhere (i first tried own ip address didn't work set now). don't have skip-networking activated.

i added privileges database want access user i'm using. flushed privileges right after.

i set iptables allow connection through port 3306 anywhere :

21 accept tcp -- 0.0.0.0/0 0.0.0.0/0 state new tcp dpt:3306

i checked netstat make sure mysql listening correctly, got :

tcp 0 0 0.0.0.0:3306 0.0.0.0:* listen 18878/mysqld

i tried telnet <ip> 3306 , message :

could not open connection host, on port 3306: connect failed

i've been searching , trying figure out i'm not sure i'm doing wrong. works locally can't work remotely.


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -