How to Resolve MySQL ERROR 1007 (HY000)

In this post, we will look into the MySQL error 1007. We will see what is MySQL error 1007? How does MySQL error 1007 arise? What steps we can follow to get rid of this error 1007.

What is MySQL Error 1007

When you execute MySQL queries, you might get a MySQL 1007 error. Error 1007 in MySQL is related when we are trying to create a new database with the same name which is already present in the MySQL database.

Suppose there is test database already present in MySQL and you try to execute following MySQL create database statement.

Create database test;

then you will get error

ERROR 1007 (HY000): Can’t create database ‘test’; database exists

How to resolve MySQL Error 1007

If you don’t want to get Error 1007 in MySQL, then you can make use of if not exists clause in your create database statement.

create database if not exists test;

if you use if not exists clause it will not throw 1007 error. it will just throw a warning.