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.




Recent Posts:




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, How Tos, Blogs, Articles, etc.