Databases

How to Optimize a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. Click on the Expand icon from the navigation tree in the left sidebar. 4. Scroll down and mark Check All. Click on the drop-down option and select Optimize tables. The table has been successfully optimized.

How to Delete a Database in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. Under Current Databases, you can see a list of all your databases. Locate the database you want to remove and click on Delete. 4. Click on Delete Database.

How to Rename a Database in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. Under Current Databases, you can see a list of all your databases. Locate the Database and then click on Rename.4. Change the database name and click on Proceed.