When a table is removed from a database, all records and fields that it contains will be lost. You can remove any table, although deleting those in the mysql database is a bad idea as they contain important MySQL access control information.
To remove one, follow these steps:
1. | |
2. | Click on the Drop Table button below the list of fields. This will take you to a confirmation page that asks if you are sure and tells you how many records will be deleted. |
3. | To go ahead, click the Drop Table button again. Once it has been removed, you will return to the list of surviving tables in the database. |
It is also possible to delete an entire database and all the tables and records in it. Any database can be removed, but deleting the mysql database is a very bad idea. As usual, unless you have made a backup there is no way to undo the deletion.
Assuming you really want to delete a database, follow these steps:
1. | On the main page, click on the icon for the database that you want to remove. |
2. | Hit the Drop Database button below the list of tables. A confirmation page will be displayed, telling you how many tables and records will be lost if you go ahead. |
3. | To continue with the deletion, click the Drop Database button and you will return to the module's main page when it is done. |
4. |
52.15.179.139