Delete a database in phpMyAdmin

Phpmyadmin

Phpmyadmin Problem Overview

By mistake, I have created a duplicate database in the phpMyAdmin page of cPanel. I want to delete this database, but I am not able to find any delete button in the UI.

How to delete a database in phpMyAdmin?

Phpmyadmin Solutions

Solution 1 - Phpmyadmin

On phpMyAdmin 4.1.9:

database_name > Operations > Remove database

enter image description here

Solution 2 - Phpmyadmin

After successful login to cPanel, near to the phpMyAdmin icon there is another icon MySQL Databases; click on that.

enter image description here

That brings you to the database listing page.

In the action column you can find the delete database option click on that to delete your database!

Solution 3 - Phpmyadmin

Screenshot

  1. Go to phpmyadmin home page.
  2. Click on 'Databases'.
  3. Select the database you want to delete. (put check mark)
  4. Click Drop.

Solution 4 - Phpmyadmin

Taking a queue from michael's answer above, I was unable to find the DROP Database command on my phpMyAdmin console in the localhost.

Apparantly I was missing a setting. Go to config.inc.php file of the phpMyAdmin folder, and add this:

$cfg['AllowUserDropDatabase'] = true;

Save and restart the local server and the command appears inside the console.

Solution 5 - Phpmyadmin

You can delete the database in Cpanel.

In Cpanel go to databases and there you will see all created databases and you can delete this database.

http://docs.cpanel.net/twiki/bin/view/AllDocumentation/CpanelDocs/MySQLDatabases#Delete a Database

or other wise on live server if user have privileges you can run command in sql tab of phpmyadmin.

drop database databasename;

Solution 6 - Phpmyadmin

You can follow uploaded images

enter image description here

Then select which database you want to delete

enter image description here

Solution 7 - Phpmyadmin

If you want to delete your database from phpmyAdmin or mySQl. Simply go to SQL command and write command "drop DATABASE databasename;"

Example: drop DATABASE rainbowonlineshopping;

enter image description here

Then click on "Go" Button. Your Database will be deleted and you get information like this

enter image description here

Solution 8 - Phpmyadmin

database_name -> Operations -> Remove database -> click on drop the database (DROP)

Solution 9 - Phpmyadmin

There are two ways for delete Database

  1. Run this SQL query -> DROP DATABASE database_name
  2. Click database_name -> Operations ->Remove Database

Solution 10 - Phpmyadmin

Open the Terminal and run

 mysql -u root -p

Password is null or just enter your mysql password

Ater Just Run This Query

 DROP DATABASE DBname;

If you are using phpmyadmin then just run

 DROP DATABASE DBname;

Solution 11 - Phpmyadmin

Follow the following steps to delete database in PhpMyAdmin.

  1. Select your database.
  2. Choose the "Operations" tab.
  3. On this page under remove database, you will find a "Drop the database (DROP)"

Hope this helps.

Solution 12 - Phpmyadmin

> How to delete a database in phpMyAdmin?

From the Operations tab of the database, look for (and click) the text Drop the database (DROP).

Solution 13 - Phpmyadmin

select database on the left side. Then on the right-central top you can find Operations. In that go for remove database (DROP). That's all.

Solution 14 - Phpmyadmin

The delete / drop option in operations is not present in my version.

Go to CPanel -> MySQLDatabase (icon next to PhPMyAdmin) -> check the DB to be delete -> delete.

Solution 15 - Phpmyadmin

  1. Connect to your localhost.
  2. Open your favorite browser.
  3. Make sure your localhost is working.
  4. Type in url= localhost.
  5. Scroll down click on phpadmin once phpadmin is open.
  6. Click on database.
  7. Mark check the database you want remove.
  8. Click on drop.

If this don't work

  1. Click on database go to operation
  2. Click drop database

Solution 16 - Phpmyadmin

Go to operations tab for the selected database and click "Drop the database (DROP)" to delete it.

Solution 17 - Phpmyadmin

It will work 100%. Go to your xampp installation directory.

`D:\xampp\phpMyAdmin\libraries\config.default.php`

Steps:

Step1: Go the line number 777 and replace this

$cfg['AllowUserDropDatabase'] = false; to $cfg['AllowUserDropDatabase'] = true;

Step2: restart the xampp

Problem image

Solution Image

Categories
Recommended Phpmyadmin Solutions

Previous Solution:

Setup git in Intellij terminal

WindowsGitIntellij Idea

Next Solution:

How can I overwrite a getter method in an ActiveRecord model?

Ruby on-RailsRubyRails ActiverecordGetter Setter

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestioncoderView Question on Stackoverflow
Solution 1 - PhpmyadminMars RobertsonView Answer on Stackoverflow
Solution 2 - PhpmyadminpsanjibView Answer on Stackoverflow
Solution 3 - Phpmyadminuser3642940View Answer on Stackoverflow
Solution 4 - PhpmyadmincodegasmView Answer on Stackoverflow
Solution 5 - PhpmyadminJason WView Answer on Stackoverflow
Solution 6 - Phpmyadminuser9097004View Answer on Stackoverflow
Solution 7 - PhpmyadminAvinash Kumar SinghView Answer on Stackoverflow
Solution 8 - PhpmyadminVayodya TamariView Answer on Stackoverflow
Solution 9 - PhpmyadminumutekiciView Answer on Stackoverflow
Solution 10 - PhpmyadminShabeer KView Answer on Stackoverflow
Solution 11 - PhpmyadminRajneesh ShuklaView Answer on Stackoverflow
Solution 12 - PhpmyadminIsaac BennetchView Answer on Stackoverflow
Solution 13 - PhpmyadminS K padalaView Answer on Stackoverflow
Solution 14 - Phpmyadminuser2060451View Answer on Stackoverflow
Solution 15 - PhpmyadminEdgardasunView Answer on Stackoverflow
Solution 16 - PhpmyadminBilalView Answer on Stackoverflow
Solution 17 - PhpmyadminKaleemullahView Answer on Stackoverflow