Mysql8设置登录密码

借鉴 https://blog.csdn.net/Shuju15/article/details/109001393

1 sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf 加  skip-grant-tables

2 mysql -uroot  -p 登录mysql

3 use mysql;

4 UPDATE user SET authentication_string="" WHERE user=“root”;关键

5 flush privileges;

6ALTER USER 'root'@'localhost' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY 'Qq@dddddd';密码需要复杂一些

7 flush privileges;

8exit;

9删除 skip-grant-tables；

10 重启mysql