MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists


Error No. : #1008
Error Type : Server Error
Error Code : SSQLSTATE: HY000 (ER_DB_DROP_EXISTS)
Error Message: Can't drop database '%s'; database doesn't exist Server Error
MySQL 1008 Error DROP
MySQL 1008 Error DROP

This is again a very Trivial MySQL error. The Server returns error code 1008 i.e. ER_DB_DROP_EXISTS when you try to execute a DROP Command to delete a database that does not exist.

SQL query:
drop database mydb
MySQL said: Documentation

#1008 - Can't drop database 'mydb'; database doesn't exist 

If you have a script that contains DROP command check if its getting executed twice or the database really exists.






Hello there!,

You are using AdBlocker!

I am an independent developer trying to help fellow developers and students to resolve issues faced on a day-to-day basis, we 'Code to Care' . There is a lot of expenses involved in hosting and managing a website that's the reason we have ads.

A humble request to you to disable adBlocker on Code2care.org and support us pay our bills.

Thanks,
Cod2care - Line's of code for change.

To see contents reload page after unblocking
Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities. Students and Software Developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include Learnings, Video Tutorials, Code Snippets, Tips-n-tricks, How Tos, Blogs, Articles, etc. on various platforms like Windows, Mac, Linux, Mobile platforms, etc. Technologies/Languages like Java, Objective-C, PHP, .Net, Android, SharePoint, jQuery, HTML, CSS, etc.