Hello,

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?

Thanks.

Recommended Answers

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.

Jump to Post

All 3 Replies

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.