MySQL Error 1045: Access Denied for User

MySQL error 1045 (Access Denied for User) explained: what it means, why it happens, and how to fix it — with copy-paste code examples.

MySQL Error Code 1045 MySQL Last verified 2026-08-19

Quick Answer

Check the exact user@host MySQL matched: the message includes the account and the client host. If that does not apply, verify the password: `ALTER USER 'app'@'localhost' IDENTIFIED BY '...'` after any reset — the full checklist is below.

Error Code

MySQL Error Code: 1045
Official name: Access Denied for User
Service: MySQL

What does this error mean?

Access denied for user '%s'@'%s' (using password: %s)

Common Causes

How to Fix

  1. Check the exact user@host MySQL matched: the message includes the account and the client host
  2. Verify the password: `ALTER USER 'app'@'localhost' IDENTIFIED BY '...'` after any reset
  3. If connecting from another machine, ensure the account exists for that host: 'app'@'%' or 'app'@'10.0.0.%'
  4. Grant access to the database: `GRANT ALL PRIVILEGES ON dbname.* TO 'app'@'localhost'; FLUSH PRIVILEGES;`
  5. Old drivers + caching_sha2_password: update the client library or create the user with mysql_native_password

Code Examples

Diagnose with the CLI bash 
mysql -u app -p -h 127.0.0.1 mydb
# if 'Access denied', the account/host/password combo is wrong

Reproducing with the CLI isolates config problems from code problems.

Fix grants and host mask sql 
CREATE USER 'app'@'10.0.0.%' IDENTIFIED BY 'secret';
GRANT ALL PRIVILEGES ON mydb.* TO 'app'@'10.0.0.%';
FLUSH PRIVILEGES;

Creates the account for the app server's network and grants access to the schema it needs.

Framework-Specific Fixes

nodejs-mysql2

Keep credentials in env vars and log only the user@host part of the error, never the password.

const pool = mysql.createPool({
  host: process.env.DB_HOST,
  user: process.env.DB_USER,
  password: process.env.DB_PASS,
})
python-sqlalchemy

Check the URL parts (host/user/db) and confirm the account host mask matches the app server.

# mysql+pymysql://user:pass@host:3306/dbname
# 'Access denied' -> verify user/pass and host mask
php-pdo

Wrap connect in try/catch and surface a friendly message while logging the real error.

try {
  $pdo = new PDO('mysql:host=' . $host . ';dbname=' . $db, $user, $pass);
} catch (PDOException $e) {
  error_log($e->getMessage());
  exit('Database connection failed');
}

You Might Also Like

1146 Table Doesn't Exist Table '%s.%s' doesn't exist 1064 SQL Syntax Error %s near '%s' at line %s 1048 Column Cannot Be Null Column '%s' cannot be null

Frequently Asked Questions

Why am I seeing MySQL error 1045?

Most often this happens when wrong password in the connection string or config file, or when the MySQL user does not exist, or exists only for a different host (user@'localhost' vs connecting remotely).

How do I fix MySQL error 1045?

Check the exact user@host MySQL matched: the message includes the account and the client host.

Which frameworks have documented fixes for error 1045?

This page documents fixes for: nodejs-mysql2, python-sqlalchemy, php-pdo.

Official Sources

This page is based on the official MySQL documentation linked below and adds practical troubleshooting guidance on top.