Knowledge Base
How To Create And Maintain MySQL Databases in cPanel?
Follow these steps to create a MySQL database in cPanel:
>>Login to your cPanel account.
>>Click on the option “MySQL Databases”.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-607.png)
Enter a name for your database in the “Create New Database” section.
Select the “Create Database” option as shown below.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-608.png)
Once, the database is created it will show up in “Current Database” section as shown below.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-609.png)
To manage the databases from cPanel:
You can manage and add/delete users to database from ‘MySQL Users’ option in cPanel.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-610.png)
You can assign/remove privileges to database users from ‘MySQL Privileges’ option in cPanel
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-611.png)
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-612.png)
To create backup of database you can use ‘MySQL Backups’ option in cPanel as follows.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-613.png)
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-614.png)
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-615.png)
To optimize database follow the steps, cPanel >> phpMyAdmin >> select database name >> at the bottom, select option ‘Check all’ and from dropdown menu select ‘Optimize table’ option and your database will be optimized, follow below steps for detail reference.
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-616.png)
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-617.png)
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-618.png)
![](https://kb.dollar2host.com/wp-content/uploads/2023/06/image-619.png)