ERROR 1007 (HY000): Can't create database (dbName); database exists

Cause

This error message is seen in MySQL when the database we want to create, already exists in MySQL server.

Solution

The problem can be solved by either changing the database name in our "CREATE DATABASE" command or dropping the old database. You can drop a database by "DROP DATABASE" command.

mysql> DROP DATABASE (DatabaseName);