Can't Delete MySQL Databases

Status
Not open for further replies.

chaines51

New Member
Messages
1
Reaction score
0
Points
0
I've tried everything:
  • CPanel -> MySQL Databases -> Delete
  • PHPMyAdmin Deletion (DROP DATABASE statements are disabled)
  • Deleted all users, and tried both the above again
  • added a new user with all permissions, and tried the above again
Nothing seems to be working. How do I delete these databases?

EDIT: I just deleted all tables, and renamed the database within PhpMyAdmin, but I still think that I should be able to delete databases? Is there a reason this isn't working?
 
Last edited:

misson

Community Paragon
Community Support
Messages
2,572
Reaction score
72
Points
48
The first option should work. The second shouldn't as user DB accounts don't have global drop privilege (only per-DB drop privileges for cPanel user account). The last two shouldn't make a difference. Also, I don't believe table type or foreign key references should make a difference, unless perhaps a table in another database has a foreign key reference to a column in a table in the database you're trying to delete.

As for why what should have happened didn't, what happened instead? Always state the behavior you get (which includes error messages) along with the behavior you expected. When you tried to delete the database via the MySQL Databases panel, did you get an error message?
 
Status
Not open for further replies.
Top