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


Posted on : Mon, 12th Oct 15 01:41 pm (Updated on : Mon, 12th Oct 15 01:41 pm) UTC
Author : Code2care
2314 votes

  • 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

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

SQL query:

drop database mydb
MySQL said: Documentation

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

MySQL 1008 Error DROP


MySQL Error : #1008

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

Code2care's mission is to share varied knowledge in technical and non-technical areas gathered during day-to-day learnings and development activities so that our visitors can leverage this portal to find solutions to their queries without re-inventing the wheel. Technical posts include Learnings, Tutorials, Video Tutorials, Code Snippets, Tips-n-tricks.

Follow us : Facebook - Twitter - Google +