• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Issue Remote connection for mysql database impossible

NamNam

Basic Pleskian
Hi, 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 ?
 
Back
Top