How to delete a Database from the phpMyAdmin

Here are the safe, step-by-step ways to delete a database using phpMyAdmin. No coding needed.

Method 1: Delete a Database from the phpMyAdmin Home Page (Recommended)

1. Log in to phpMyAdmin
   • Usually at http://localhost/phpmyadmin or via your hosting control panel.
2. Go to the “Databases” tab (top menu).
3. You’ll see a list of databases.
   • Check the box next to the database you want to delete.
4. Scroll down and click “Drop”.
5. A confirmation popup appears.
   • Click OK / Yes.

The database is permanently deleted.

Method 2: Delete from Inside the Database

1. In the left sidebar, click the database name.
2. Click the “Operations” tab.
3. Scroll to Remove database.
4. Click “Drop the database (DROP)”.
5. Confirm.

Method 3: Delete Using SQL Command

Use only if you know the exact database name.

1. Select any database or click SQL tab.
2. Run this command:

DROP DATABASE database_name;

Example:

DROP DATABASE my_test_db;

3. Click Go.

Important Warnings

• Deletion is permanent — cannot be undone.
• Backup first if needed:
  • Select database → Export → Quick → Go

Common Issues

Database not visible?

• You may not have permission.
• Log in as a user with full privileges (e.g., root).

Drop option disabled?

• Your hosting provider may restrict database deletion.