Resolved Cannot access database remotely

[Fabs87]

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?

 

[eilko]

• 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?