How to Delete an Entire Database With PhpMyAdmin

Deleting a database using phpMyAdmin is a relatively simple process that should only take a couple of minutes. To do this you will need phpMyAdmin software installed on your Web space, as well as your username and password for it.

Difficulty: Moderately Easy

Instructions

1. Log into the phpMyAdmin interface on your Web space. You will need the username and password assigned by your Web-hosting provider.

2. Select the database you wish to delete in the drop-down database selection box on the left. Make sure you pick the right one!

3. Click the Drop button on the far right. You will be prompted with a confirmation pop-up, informing you that "You are about to DESTROY a complete database! Do you really want to DROP DATABASE [NAME]?" (where [NAME] is the name of your database).
   

4. Click "OK" to delete the entire database, and you’re done.

Tips & Warnings

• You may want to make a backup of the database before you delete it.
• If for some reason there is no Drop button in your phpMyAdmin interface for a particular database, it may be protected. Contact your hosting provider for more information.
• Make absolutely certain that you are deleting the correct database.
• Remember that phpMyAdmin is a powerful tool. If you don’t know what something does, don’t touch it, as you may inadvertently ruin your entire database.

[sathyancatari]

on 10/9/2008 I have an article comparing phpmyadmin and MS-Access that I would like to publish here. Where do I get help?

Thanks
[e-mail]