• 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

Resolved Cannot access database remotely

Fabs87

New Pleskian
Hi!

Ich have problems connecting to my MYSQL-database from my local machine (Windows 10). I've tried several tools (MySQL Workbench, PHP-Storm and from an Laravel-Application). It's only possible connecting via SSH-Tunnel.

I've created an user with the needed privilegs (connect from everywhere/connect from listed ip). Of course, my server-firewall is activated, but as the documentation says, this has no effect on MySQL because of MySQL ACL (Doc-Page).

Any ideas how to solve this problem?
 
  • Access control lists. For MySQL database users, the access control is handled by the native security mechanism - MySQL access control lists (ACL). Custom rules are added to ACL. If the Plesk firewall is running, then it must allow incoming connections to MySQL. Otherwise, settings for remote connections in ACL will not work.
have you checked the bold part?
 
Back
Top