'Delete a database in phpMyAdmin
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?
Solution 1:[1]
After successful login to cPanel, near to the phpMyAdmin icon there is another icon MySQL Databases; click on that.
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 2:[2]
On phpMyAdmin 4.1.9:
database_name > Operations > Remove database
Solution 3:[3]
- Go to phpmyadmin home page.
- Click on 'Databases'.
- Select the database you want to delete. (put check mark)
- Click Drop.
Solution 4:[4]
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:[5]
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:[6]
You can follow uploaded images
Then select which database you want to delete
Solution 7:[7]
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;
Then click on "Go" Button. Your Database will be deleted and you get information like this
Solution 8:[8]
database_name -> Operations -> Remove database -> click on drop the database (DROP)
Solution 9:[9]
There are two ways for delete Database
- Run this SQL query -> DROP DATABASE database_name
- Click database_name -> Operations ->Remove Database
Solution 10:[10]
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:[11]
Follow the following steps to delete database in PhpMyAdmin.
- Select your database.
- Choose the "Operations" tab.
- On this page under remove database, you will find a "Drop the database (DROP)"
Hope this helps.
Solution 12:[12]
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:[13]
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:[14]
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:[15]
Go to operations tab for the selected database and click "Drop the database (DROP)" to delete it.
Solution 16:[16]
- Connect to your localhost.
- Open your favorite browser.
- Make sure your localhost is working.
- Type in url= localhost.
- Scroll down click on phpadmin once phpadmin is open.
- Click on database.
- Mark check the database you want remove.
- Click on drop.
If this don't work
- Click on database go to operation
- Click drop database
Solution 17:[17]
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
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow