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) GMT
Author : Code2care

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


We are operating with limited resources due to COVID-19 - Stay Safe!


We stands in support of racial equality!

Follow us : Facebook - Twitter