Open MySQL / MariaDB Server globally
Preface
In this article, we would like to show you how you can open your MySQL / MariaDB server globally for external access, e.g. to use database management software or to operate the server as a dedicated database server.
When your server is delivered, external access to the MySQL server is not possible for security reasons.
Prerequisites
- Server with activated MySQL / MariaDB service
- Plesk Control Panel
External access to a database is a potential security risk, only open external access if you need it.
Allow external access
To allow external access, log in to your Plesk Control Panel via the customer center to make the setting there.
Once you have successfully logged in to the Plesk Control Panel, you can navigate to Tools & Settings → Database Server and select the desired service there.
In our case, we want to activate external database access for MariaDB, so we click on localhost in the MariaDB line.
Once there, we can see which databases are operated by the MariaDB service, to allow the setting for external access, check Allow local MySQL server to accept external connections.
By clicking on OK you can confirm the setting, external access is now permitted and it is possible to connect to the database using any database management software.
Do not allow external access
If you do not want to allow external access, you can simply revoke the permission under Tools & Settings → Database server → Service used by unchecking the box.
Click on OK to confirm the setting and no more external connections are permitted from now on.