I am using xampp for mysql:
When I try to delete a database :
"DROP DATABASE" statements are disabled.
That statement appears. Why is it? What other alternative I could use?
Check your privileges on the user for MySQL, there is a privilege you have to set.
If it is root, then there is no drop problem.
You need to set drop permission for the account you're using. Log in as root and execute the following sql script -
GRANT DROP ON *.* TO 'user'@'localhost';
where user is the account in question.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.