Deleting a MySql Database Under XAMPP

This tutorial assumes that you have XAMPP 1.7.3 installed.

The procedure should be the same for other versions of XAMPP.

A XAMPP installation procedure for Windows XP can be found here.

Click on images for full sized versions.

(1) Enter http://localhost/phpmyadmin into your browser’s URL field. This will bring you to the phpmyadmin main page.

delete-mysql=db=xampp-1

(2) Click on the Databases tab.  This will bring you to a page listing all your databases.

delete-mysql-db-xampp-2

(3) Select the databases you wish to drop by clicking on the checkbox next to them. Then click on the drop icon located below the databases

cdcol is the cd collection sample database that comes with XAMPP – it is safe to delete, if you like, just be WARNED that the application will no longer work.

information_schema is a necessary database for XAMPP to run correctly. Do NOT delete it. (You shouldn’t be able to select it, anyway.)

mysql is another essential database for XAMPP to run correctly. Do NOT delete it. (You shouldn’t be able to select it, anyway.)

phpmyadmin is essential for phpmyadmin to run correctly. Do NOT delete it. Unfortunately, it is possible for you to select this – DON’T.

All other databases are the ones you created and are safe to delete if you wish. WARNING: deleting a database will render the application it was created for inoperable.

delete-mysql-db-xampp-3

(4) Confirm you wish to delete the databases listed and click on Yes.

delete-mysql-db-xampp-4

The term drop is used with databases because, typically, they do not actually delete the database or fields or records, but rather mark them not to be used, i.e. dropped from use.