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
Post a Comment