1046 MySQL Origin: Data Last updated 15 Oct 2026

MySQL ERROR 1046 (3D000): No database selected

A query referenced tables without a database selected (no USE and no db in the connection).

Exact message you may see No database selected
Seen on: MySQL

Meaning

Connections without a default database (DSN missing dbname) or imports without USE fail on the first unqualified table.

Common causes

  • Connection string without database name
  • SQL dump missing USE statement
  • phpMyAdmin import with no database selected

⚡ Quick fix

  1. Add the database to the DSN/connection
  2. Run USE dbname first
  3. Select the database before importing in phpMyAdmin

Detailed fix by platform

MySQL

  1. mysql -u app -p appdb < dump.sql

How to diagnose

  1. Connection — Database specified?
  2. Script — USE statement?

🔧 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):

1000 — Cloudflare Error 1000: DNS points to prohibited IP (Cloudflare)10001049 — MySQL ERROR 1049 (42000): Unknown database 'x' (MySQL)10491153 — MySQL ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes (MySQL)11531227 — MySQL ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation (MySQL)122722021 — ERROR: invalid byte sequence for encoding "UTF8": 0x00 (PostgreSQL)22021AADSTS90002 — AADSTS90002: Tenant 'x' not found (Azure)AADSTS90002AH00558 — Apache: AH00558: apache2: Could not reliably determine the server's fully qualified domain name (Nginx / Apache)AH00558api_version_invalid — API Error: Invalid or unsupported API version (API)api_version_invalid1046

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.