1. 用户身份认证错误
Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost' (using password: YES)
- 出现这种报错时,错误码为1045
code: 'ER_ACCESS_DENIED_ERROR', errno: 1045,
你可以通过:
- 创建新用户(而不是使用 root)
mysql> CREATE USER 'new_user'@'%' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)
- 授予:
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW