Facebook
TwitterHi, i try to remote my mysql database but connection is refused systematicly...
I've add user with authorized remote from any host
Same for mysql server...
I've commented this line
bind-address = ::ffff:127.0.0.1
and
sql_mode=ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
and
add this line :
port = 3306
I've restart mysql and server.
I've try to add this :
sudo iptables -I INPUT -p tcp --dport 3306 -m state --state NEW,ESTABLISHED -j ACCEPT
sudo iptables -I OUTPUT -p tcp --sport 3306 -m state --state ESTABLISHED -j ACCEPT
And nothing...
I've try to add database at a website or not... same...
Can you help me ?
I've add user with authorized remote from any host
Same for mysql server...
I've commented this line
bind-address = ::ffff:127.0.0.1
and
sql_mode=ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
and
add this line :
port = 3306
I've restart mysql and server.
I've try to add this :
sudo iptables -I INPUT -p tcp --dport 3306 -m state --state NEW,ESTABLISHED -j ACCEPT
sudo iptables -I OUTPUT -p tcp --sport 3306 -m state --state ESTABLISHED -j ACCEPT
And nothing...
I've try to add database at a website or not... same...
Can you help me ?
