• We value your experience with Plesk during 2025
    Plesk strives to perform even better in 2026. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2025.
    Please take this short survey:

    https://survey.webpros.com/
  • On Plesk for Linux mod_status is disabled on upgrades to improve Apache security.
    This is a one-time operation that occurs during an upgrade. You can manually enable mod_status later if needed.

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