Introduction

This article provides an overview of managing MySQL databases in the Webdock dashboard, including creating and deleting databases, accessing credentials, and configuring remote database access.

The Database Management Screen

Note: The database management feature is available only on servers running our LEMP/LAMP stacks. It is not available on servers provisioned with clean OS images.

The database management screen provides controls for creating and managing MySQL databases. Here you can create a database with the given name and assign either a new or existing user, with an optional password, then use ‘Create Database’ to provision it. The ‘Existing Databases’ section lists current databases with their name, creation timestamp, and assigned user, along with a ‘Delete Database’ action for removal.

Servers running LEMP/LAMP stacks include a default MySQL compatible database, MariaDB, with the credentials (host, username, and password) available on the main server screen.

Remote MySQL access can be enabled by deploying the ‘Enable Remote MySQL Access’ script from the ‘Server Scripts’ screen. After deployment, create a new database user with ‘remote’ included in the username to allow external connections. For existing databases using existing users, remote access must be configured manually via the command line by updating user privileges and network binding settings.

Note: Enabling remote MySQL access can expose the database to external connections and potential security risks; ensure appropriate access controls and network restrictions are configured.

See the following guides for hardening the remote security and enabling remote access for existing users depending on the database version: For MariaDB > 10.6 and for MariaDB < 10.6

Conclusion

The database management feature allows you to quickly set up and maintain application databases without manual configuration, reducing setup time and operational overhead. With optional remote access, you can integrate your databases with external services, development environments, or third-party tools.