Managing MySQL Databases
Last updated: June 12th 2023
Introduction
This article shows where you can manage your database from the Webdock dashboard.
The Database Management Screen
Note: The database management tool applies only to the Webdock servers running on our LEMP / LAMP stacks. Servers running on clean OS images do not see the database management tool.
Here's how it looks:
You can manage your database here - creating new or deleting existing databases. The LEMP / LAMP stacks come with a DB created, and the credentials for the DB will be visible on the main server screen. If you need to create additional databases, this is the place where you can do that.
Webdock also simplifies the process of giving remote access to your database. All you need to do is to deploy the "Enable Remote MySQL Access" script from the server scripts screen and then add a new database with a username that contains "remote" in the username. For existing DBs that use the existing DB user, you can manually enable remote access to them from the command line. These guides will help you with that: For MariaDB > 10.6 and for MariaDB < 10.6
That's it.
Conclusion
This article showed you where you can manage your database from the Webdock dashboard and also how to enable remote access to your DB.
Related articles
-
Introducing The Webdock Dashboard
A glimpse of how our dashboard looks.
-
Server Management
Brief overview of management tools you'll see in the Webdock dashboard
-
Profile Upgrade and Downgrade
A brief description of our profile change page.
-
Snapshot Management
A brief article on how you can leverage Webdock snapshots
-
Managing Cron Jobs
A short article on how you can create cron jobs
-
Deploying Server Scripts
The easy way to deploy your scripts!
-
Manage PHP
A quick way to change PHP version
-
Managing Shell Users
A article on how to manage shell users and WebSSH to SSH into your server
-
File Manager
Create FTP users and manage your files in the webroot from the dashboard.
-
Managing Your Server Identity
Domain routing for your server using the Server Identity tool.
-
Managing SSL Certificates
-
Sending Emails Using Postmark
A brief article showing how to link your domain to Postmark for sending emails!
-
Email Forwarding Using ImprovMX
Forwarding incoming emails on your domain to your email box using ImprovMX
-
Managing WordPress
Easy installation and managing WP with our WP add-on