MGT CloudPanel - Databases
Adding a Database
To add a new database, click on the left menu on Databases.
Enter the name of the database and click on the button Create Database.
![Adding a Database](/docs/img/mgt-cloudpanel/databases/new_database.png)
Deleting a Database
To delete a database, click on the left menu on Databases.
Click on the delete button of the database you want to delete.
![Adding a Database](/docs/img/mgt-cloudpanel/databases/delete_database.png)
Attention
Also all database backups from /home/cloudpanel/backups/$databaseName/ will be deleted.
You may want to take a copy before.
Adding a Database User
To add a database user for a database, click on the left menu on Databases.
Click on the view button:
![View Database](/docs/img/mgt-cloudpanel/databases/view_database.png)
- Enter the Username and Password and click on the button Create User.
![Adding a Database User](/docs/img/mgt-cloudpanel/databases/create_user.png)
Deleting a Database User
To delete a database user for a database, click on the left menu on Databases.
Click on the view button:
![View Database](/docs/img/mgt-cloudpanel/databases/view_database.png)
- Click on the button Delete to delete the user.
![Delete Database User](/docs/img/mgt-cloudpanel/databases/delete_database_user.png)
phpMyAdmin
To manage a database via phpMyAdmin, click on the view button of the database.
Click on the button phpMyAdmin to manage the database.
![Manage the database via phpMyAdmin](/docs/img/mgt-cloudpanel/databases/manage_database.png)
Database Backups
All databases are backed up once a night. The database dumps of each database can be found in the following directory:
/home/cloudpanel/backups/$databaseName/
Furthermore, we are doing full hourly backups of the entire instance, including all databases.
In case of an emergency, we can restore an instance from an image and restore a specific database.
All Multi and Auto Scaling environments that use Amazon RDS as database service can be restored to a specific time.
Remote Access
For remote database access, we need to whitelist IPs in the AWS security group.
Please open a technical support ticket and provide the IPs to whitelist.