Knowledgebase

How to delete MySQL database tables with phpMyAdmin

You can drop MySQL database tables using phpMyAdmin. To access phpMyAdmin go to the Databases section of the Pixie control panel and click on the phpMyAdmin link that's in the black area on the right side of the screen. Inside phpMyAdmin click on the database that contains the tables that you want to drop. All the databases that you have created are listed in the frame on the left.

After you click on the name of the database its tables will be displayed in the right frame. Mark the checkbox in front of the table(s) that you want to delete, scroll down the page and from the drop-down menu With selected choose Drop. Then on the next screen confirm that you want to drop the table(s) by clicking on the Yes button.

If you want to empty the whole database, on the page with the database tables click on the Check All button (it's at the bottom of the page next to the With selected drop-down menu). Then just select Drop from the drop-down menu and confirm. Note that this will delete all the tables in the database thus emptying it, but the database itself won't be deleted. The recommended way for deleting a database is from the Databases section of the Pixie control panel.

Was this answer helpful?

 Print this Article

Also Read