The user was created but never granted privileges on the specific database. GRANT was applied to a different database name (typo or wrong schema). The database was recreated or renamed after the original GRANT was issued

Step 1: Check current grants: `SHOW GRANTS FOR 'your_user'@'%';`. Step 2: Grant database-level access: `GRANT SELECT, INSERT, UPDATE, DELETE ON your_db.* TO 'your_user'@'%';`. Step 3: Apply changes: `FLUSH PRIVILEGES;`

High severityauthentication

Power BI Refresh Error:
1044

What does this error mean?

The MySQL user authenticated successfully but has no privileges on the target database.

Common causes

1The user was created but never granted privileges on the specific database
2GRANT was applied to a different database name (typo or wrong schema)
3The database was recreated or renamed after the original GRANT was issued

How to fix it

1Step 1: Check current grants: `SHOW GRANTS FOR 'your_user'@'%';`
2Step 2: Grant database-level access: `GRANT SELECT, INSERT, UPDATE, DELETE ON your_db.* TO 'your_user'@'%';`
3Step 3: Apply changes: `FLUSH PRIVILEGES;`

Frequently asked questions

What is the difference between MySQL error 1044 and 1045?

Error 1045 means authentication failed (wrong password or host mismatch). Error 1044 means authentication succeeded but the user lacks database-level privileges.

How do I give a dbt service account the minimum required privileges?

Run `GRANT SELECT, CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, REFERENCES ON your_db.* TO 'dbt_user'@'%'; FLUSH PRIVILEGES;`

Can MetricSign alert me when a pipeline fails due to this error?

Yes — MetricSign surfaces ADF pipeline failures with root cause error codes, so your team knows immediately which MySQL credential issue is blocking data refresh.

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