• The APS Catalog has been deprecated and removed from all Plesk Obsidian versions.
    Applications already installed from the APS Catalog will continue working. However, Plesk will no longer provide support for APS applications.
  • Please be aware: with the Plesk Obsidian 18.0.78 release, the support for the ngx_pagespeed.so module will be deprecated and removed from the sw-nginx package.

Resolved Cannot access database remotely

Fabs87

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?
 
You must log in or register to reply here.

Similar threads

weareimpulse
Question Allow remote connections from any host, not working
Replies
2
Views
4K
weareimpulse
weareimpulse
M
Resolved How to configure Plesk databases to allow access from Plesk docker container
Replies
6
Views
4K
milanbx
M
S
Issue cannot connect to remote mysql form specific docker container
Replies
0
Views
2K
stefanoostwegel
S
llucas
Question Remote access to server database
Replies
0
Views
1K
llucas
llucas
M
Issue Database Connection Refused 10 mins after Deploy
Replies
1
Views
2K
scsa20
scsa20
Back
Top