Member Avatar for davy_yg

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.

  • 4 Contributors
  • 3 Replies
  • 225 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by itpixie
Member Avatar for Szabi Zsoldos

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.

Member Avatar for itpixie

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.

Edited by itpixie because: Needed to escape characters
Be a part of the DaniWeb community

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