Deleting unused WordPress tables in MySQL

When you install a WordPress plugin, it creates relevant files, folders and database tables for you. However in some cases, the plugin database tables may not be automatically erased when you remove or uninstall the plugin. This article will show you how to delete a table in MySQL using phpMyAdmin via cPanel.

Deleting unused WordPress plugin table in MySQL

1. Log in to cPanel.

   📘

   Note

   If you do not know how to log in to your cPanel account, please see this
   article.

2. In the DATABASES section of the cPanel home screen, click phpMyAdmin:
   

3. Under the Recent tab, locate the WordPress database:
   

4. Look through the list of tables and select the table you want to remove. check the box next to the tables you want to remove and click the Drop link next to the red button on the same row:

📘

Note

Always take a backup of your database before deleting any tables.

5. A confirmation message will be displayed to confirm the delete operation. Click Ok to confirm the delete process:
   

Related Articles

• Creating and executing MySQL stored functions and procedures

• Creating WordPress admin user in MySQL using phpMyAdmin

• Determining the MySQL version