MySQL Tutorial: Removing MySQL Database and User

Removing a MySQL database

Since most accounts have MySQL database creation limits, it is recommended to remove any unnecessary MySQL databases so that you are able to create more databases when necessary.

Step 1: To access the MySQL Account Maintenance Menu, click on the icon above the words MySQL Databases on the main screen of your cPanel interface.

Step 2: Click on "Delete" next to the name of the database you wish to delete.

Before deleting a database due to problems with that database, try using on the database to repair any problems with it.

Removing a MySQL user

When a MySQL user is no longer deleted, you can remove them to prevent them from having access to any databases.

Step 1: To access the MySQL Account Maintenance Menu, click on the icon above the words MySQL Databases on the main screen of your cPanel interface.

Step 2: Scroll down to the user's name under Users:

Step 3: Click on "Delete" next to the user's name to remove their MySQL user.