EC
1766
MySQLERRORNotableSchemaHIGH confidence

Named database does not exist

Production Risk

Low — operation rejected.

What this means

An operation referenced a database that does not exist on the server.

Why it happens
  1. 1Typo in the database name.
  2. 2The database was dropped or never created.
  3. 3Connecting to the wrong MySQL instance.
How to reproduce
trigger — this will error
trigger — this will error
USE nonexistent_db;

expected output

ERROR 1766 (HY000): Unknown database 'nonexistent_db'.

Fix

Verify the database name and create it if necessary

Verify the database name and create it if necessary
SHOW DATABASES LIKE 'nonexistent_db';
CREATE DATABASE IF NOT EXISTS nonexistent_db;

Why this works

Confirms whether the database exists and creates it if needed.

What not to do

✕

Sources
Official documentation ↗

MySQL 8.0 — 1766 ER_NO_SUCH_DB_ERROR

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MySQL errors