metricsign
Start free
High severityauthentication

Power BI Refresh Error:
1045

What does this error mean?

Authentication failed — wrong password or the user has no GRANT for the target host.

Common causes

  • 1Incorrect password supplied for the MySQL user account
  • 2The user exists but has no GRANT for the connecting host (e.g., granted for 'localhost' but connecting from an IP)
  • 3The user account does not exist at all on the MySQL server

How to fix it

  1. 1Step 1: Verify the user and host combination exists: `SELECT user, host FROM mysql.user WHERE user='your_user';`
  2. 2Step 2: Reset the password if needed: `ALTER USER 'your_user'@'%' IDENTIFIED BY 'new_password'; FLUSH PRIVILEGES;`
  3. 3Step 3: Grant access from the correct host: `GRANT ALL PRIVILEGES ON your_db.* TO 'your_user'@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES;`

Frequently asked questions

Why does MySQL 1045 occur even with the correct password?

The grant may be host-specific — a user granted for 'localhost' cannot connect from a different IP. Create a wildcard grant with `GRANT ... TO 'user'@'%'`.

How do I reset a forgotten MySQL root password?

Stop MySQL, start with `--skip-grant-tables`, then run `ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'; FLUSH PRIVILEGES;` and restart normally.

Can MetricSign alert me when an ADF pipeline fails with this error?

Yes — MetricSign captures ADF pipeline failures and surfaces the root cause error code so your team is notified before users see stale Power BI reports.

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

Other authentication errors