MySQL 5.7——ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

使用MySQL 5.7版本时出现  ‘’ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)‘’的错误

MySQL 5.6以后出于安全考虑root密码不能为空，系统会随机生成一个初始root密码

初始密码在data目录下的XXX.err文件中

2018-02-27T08:31:52.071642Z 1 [Note] A temporary password is generated for root@localhost: q)k4zsIwe_*d

其中q)k4zsIwe_*d就是生成的初始密码

输入密码，进去之后要重置密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';