How do I remove a MySQL database

Question

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

User · Answer

I needed to correct the privileges REVOKE ALL PRIVILEGES ONlogs   FROM  root   root    GRANT ALL PRIVILEGES ONlogs   TO  root   root WITH GRANT OPTION

User · Answer

For Visual Studio  in the package manager console   drop-database

User · Answer

If you are working in XAMPP and your query of drop database doesn t work then you can go to the operations tag where you find the column  drop the database drop    click that button and your database will be deleted

User · Answer

If your database cannot be dropped  even though you have no typos in the statement and do not miss the   at the end  enclose the database name in between backticks   mysql gt  drop database  my-database     Backticks are for databases or columns  apostrophes are for data within these   For more information  see this answer to Stack Overflow question When to use single quotes  double quotes  and backticks

User · Answer

If you are using an SQL script when you are creating your database and have any users created by your script  you need to drop them too  Lastly you need to flush the users  i e   force MySQL to read the user s privileges again   -- DELETE ALL RECIPE  drop schema  lt database name gt   -- Same as  drop database  lt database name gt    drop user  lt a user name gt   -- You may need to add a hostname e g  drop user bob localhost   FLUSH PRIVILEGES    Good luck

User · Answer

From the MySQL prompt   mysql gt  drop database  lt db name gt

User · Answer

drop database  lt db name gt   FLUSH PRIVILEGES

[mysql] How do I remove a MySQL database?

Examples related to mysql