| 错误码 | ERROR 1045 (28000) |
|---|---|
| 含义 | 用户名/密码/来源主机不匹配 |
| 定位 | SELECT user,host FROM mysql.user |
排查命令
排查命令
mysql -uroot -p -e "SELECT user, host, plugin, account_locked FROM mysql.user;"
mysql -uroot -p -e "SELECT user, host, failed_login_attempts FROM mysql.user WHERE user='app';"常见修复
常见修复
CREATE USER 'app'@'10.0.%' IDENTIFIED BY 'Str0ng#Pass';
ALTER USER 'app'@'%' IDENTIFIED BY 'NewStr0ng#Pass';
UNLOCK USER 'app'@'%';
FLUSH PRIVILEGES;MySQL 8 默认 caching_sha2_password，旧版客户端（老 Navicat、PHP 5.x）会报认证插件错误，需升级客户端或单独改该账号插件。