1007 🐬 MySQL

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

CREATE DATABASE ran for a database that already exists.

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