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?

score 302 · Accepted Answer · edited Oct 11 '16 at 19:41

302

From the MySQL prompt:

mysql> drop database <db_name>;

edited Oct 11 '16 at 19:41

shareef

9,255
13
58
89

answered Jul 04 '09 at 12:36

rnicholson

4,538
1
22
13

score 35 · Answer 2 · edited May 23 '17 at 12:34

35

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> 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?.

edited May 23 '17 at 12:34

Community

1
1

answered Apr 24 '15 at 09:06

sjas

18,644
14
87
92

2

Thanks for this answer, it didn't work for me until using backticks. – tomsihap Apr 20 '16 at 14:27
I had to enclose it on Windows. Otherwise I got `You have an error in your SQL syntax;`. – Amio.io Mar 06 '17 at 19:24

score 16 · Answer 3 · edited Nov 26 '15 at 10:39

16

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 <database_name>;
-- Same as `drop database <database_name>`

drop user <a_user_name>;
-- You may need to add a hostname e.g `drop user bob@localhost`

FLUSH PRIVILEGES;

Good luck!

edited Nov 26 '15 at 10:39

Peter Mortensen

30,738
21
105
131

answered Oct 17 '12 at 10:11

Ben

3,012
1
21
25

The above SQL doesn't work in MySQL. (Maybe this of for an old version of mysql?? – Jay Apr 10 '13 at 01:30

score 3 · Answer 4 · edited Feb 12 '14 at 05:12

3

drop database <db_name>;
FLUSH PRIVILEGES;

edited Feb 12 '14 at 05:12

Nazik

8,696
27
77
123

answered Feb 12 '14 at 04:55

anonymous

39
1

7

See your answer how it looks and try to format the answer correctly by editing it and don't simply post the code. Give some explanation or information or usage about your code. For example, see [this answer](http://stackoverflow.com/a/16893057/756941). – Nazik Feb 12 '14 at 05:14

score 0 · Answer 5 · answered Jul 19 '18 at 16:23

0

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

answered Jul 19 '18 at 16:23

DoesEatOats

625
7
13

score 0 · Answer 6 · answered Dec 20 '20 at 15:52

0

For Visual Studio, in the package manager console:

 drop-database

answered Dec 20 '20 at 15:52

Abdullah Akçam

299
4
18

score -1 · Answer 7 · edited Nov 26 '15 at 10:40

-1

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.

edited Nov 26 '15 at 10:40

Peter Mortensen

30,738
21
105
131

answered Oct 26 '14 at 09:34

Yusma Imtiaz

19
1
1
2

You can also find the location where that database is stored on windows, using xammp. Find the location where the mysql data directory is. And then delete it. For example if your database is named logs, that might be at:E:\Program Files\xampp\mysql\data\logs – DoesEatOats Jul 20 '18 at 18:00

How do I remove a MySQL database?

7 Answers7

Linked