The database was dropped or never created on this MySQL instance. The connection string contains a typo in the database name. Connecting to the wrong MySQL server (e.g., staging instead of production)

Step 1: List available databases: `SHOW DATABASES;`. Step 2: Create the database if it should exist: `CREATE DATABASE your_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;`. Step 3: Verify the connection string database name matches exactly (case-sensitive on Linux MySQL).

High severityschema

Power BI Refresh Error:
1049

What does this error mean?

The database name in the connection string or USE statement does not exist on the MySQL server.

Common causes

1The database was dropped or never created on this MySQL instance
2The connection string contains a typo in the database name
3Connecting to the wrong MySQL server (e.g., staging instead of production)

How to fix it

1Step 1: List available databases: `SHOW DATABASES;`
2Step 2: Create the database if it should exist: `CREATE DATABASE your_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;`
3Step 3: Verify the connection string database name matches exactly (case-sensitive on Linux MySQL).

Frequently asked questions

Is MySQL database naming case-sensitive?

On Linux MySQL, database names are case-sensitive by default because they map to filesystem directories. On Windows MySQL, they are case-insensitive.

How do I safely rename a MySQL database?

MySQL has no RENAME DATABASE command. Dump the database with mysqldump, create the new database, import the dump, update all connection strings, then drop the old database.

Can MetricSign detect when a database disappears and breaks pipelines?

Yes — MetricSign surfaces ADF pipeline failures with the MySQL error code, so you know immediately that the source database is missing.

Official documentation: https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html