登录MySQL提示ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

建议先看 https://mp.csdn.net/mdeditor/89819441#

1、安装好后使用$mysql -uroot -p 输入root密码测试MySQL能否使用
2、提示错误：ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)
多是因为首次登录，需要重置root密码
3、重置root密码

1. 首先修改my.cnf（5.7路径：/etc/mysql/mysql.conf.d/mysqld.cnf）文件在 [mysqld] 后添加 skip-grant-tables 即可免密登录 ，重启MySQL，$systemctl restart mysqld.service

2. 直接输入$mysql -uroot -p出现Enter password 直接按 Enter 键就可以进入mysql

3. 输入

   mysql> use mysql;
   mysql> update user set password(5.7以前)/authentication_string(5.7)=password("你的新密码") where user='root';
   mysql> flush privileges;
   mysql> quit
   

4. 再修改my.cnf文件去掉 skip-grant-tables ，再重启MySQL，即可进入MySQL
   补充：可能会报错 ERROR 1698 (28000): Access denied for user 'root'@'localhost'
   解决：重复第一步修改文件my.cnf,进入mysql

   mysql> use mysql;
   mysql> select user,plugin from user;
   +------------------+-----------------------+
   | user             | plugin                |
   +------------------+-----------------------+
   | root             | auth_socket           |更改这里的值 
   | mysql.session    | mysql_native_password |
   | mysql.sys        | mysql_native_password |
   | debian-sys-maint | mysql_native_password |
   +------------------+-----------------------+
   错误原因是因为plugin root的字段是auth_socket，替换为mysql_native_password就行了
   mysql> update user set plugin='mysql_native_password' where user='root'; 
   mysql> quit;
   

4、但是进入不能进行操作否则报错

mysql> use mysql;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

5、需要在MySQL内更改root密码且需要符合其要求必须含有数字，小写或大写字母，特殊字符，及其长度。

mysql> alter user 'root'@'localhost' identified by '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

否则报错
6、更改密码的要求（可以设置简单的密码）
必须修改两个全局参数：
首先，修改validate_password_policy参数的值

mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)

validate_password_length(密码长度)参数默认为8，我们修改为1

mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)

7、再次设置密码

mysql> alter user 'root'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)