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.
Last updated: June 9th 2023
-
Server Management
Brief overview of management tools you'll see in the Webdock dashboard
Last updated: November 26th 2023
-
Profile Upgrade and Downgrade
A brief description of our profile change page.
Last updated: November 4th 2024
-
Snapshot Management
A brief article on how you can leverage Webdock snapshots
Last updated: November 26th 2023
-
Managing Cron Jobs
A short article on how you can create cron jobs
Last updated: June 9th 2023
-
Deploying Server Scripts
The easy way to deploy your scripts!
Last updated: June 9th 2023
-
Manage PHP
A quick way to change PHP version
Last updated: November 26th 2023
-
Managing Shell Users
A article on how to manage shell users and WebSSH to SSH into your server
Last updated: June 9th 2023
-
File Manager
Create FTP users and manage your files in the webroot from the dashboard.
Last updated: November 26th 2023
-
Managing Your Server Identity
Domain routing for your server using the Server Identity tool.
Last updated: June 18th 2023
-
Managing SSL Certificates
A brief article on generating Let's Encrypt SSL certs for your app/website from the Webdock dashboard
Last updated: June 21st 2023
-
Sending Emails Using Postmark
A brief article showing how to link your domain to Postmark for sending emails!
Last updated: June 29th 2023
-
Email Forwarding Using ImprovMX
Forwarding incoming emails on your domain to your email box using ImprovMX
Last updated: June 29th 2023
-
Managing WordPress
Easy installation and managing WP with our WP add-on
Last updated: July 10th 2023