How do I remove a MySQL database?

user_54964 0
Viewed 393137

You may notice from my last question that a problem caused some more problems, Reading MySQL manuals in MySQL monitor?

My database is now unusable partly due to my interest to break things and my inability to look at error messages. I know that I should not reuse primary keys, but I would like to use them again after the removal of the database that I deteriorated. So

How can I correctly remove a MySQL database?

mysql
7 Answers

From the MySQL prompt:

mysql> drop database <db_name>;
user_140750

I needed to correct the privileges.REVOKE ALL PRIVILEGES ONlogs.* FROM 'root'@'root'; GRANT ALL PRIVILEGES ONlogs.* TO 'root'@'root'WITH GRANT OPTION;

user_26715900

For Visual Studio, in the package manager console:

 drop-database
user_70518880
Related