1007 MySQL Origin: Data Last updated 13 Oct 2026

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

CREATE DATABASE ran for a database that already exists.

Exact message you may see database existsCan't create database
Explore the map of this error Full error map →
Seen on: MySQL

Meaning

Re-running setup scripts or imports that include CREATE DATABASE.

Common causes

  • Running an install script twice
  • Dump file containing CREATE DATABASE

⚡ Quick fix

  1. Use CREATE DATABASE IF NOT EXISTS
  2. Drop it first only if you intend to replace it

Detailed fix by platform

MySQL

  1. CREATE DATABASE IF NOT EXISTS appdb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

How to diagnose

  1. Intent — Create new or reuse existing?
  2. Recent change — Did it start after a deploy, upgrade, or configuration change? Compare with the last working version.

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

1005 — MySQL ERROR 1005 (HY000): Can't create table (errno: 150 "Foreign key constraint is incorrectly formed") (MySQL)10051008 — MySQL ERROR 1008 (HY000): Can't drop database 'x'; database doesn't exist (MySQL)10081051 — MySQL ERROR 1051 (42S02): Unknown table 'x' (MySQL)10511054 — MySQL ERROR 1054 (42S22): Unknown column in 'field list' (MySQL)10541060 — MySQL ERROR 1060 (42S21): Duplicate column name 'x' (MySQL)10601067 — MySQL ERROR 1067 (42000): Invalid default value for 'created_at' (MySQL)10671071 — MySQL ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes (MySQL)10711075 — MySQL ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key (MySQL)10751007

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.