mysql8设置密码

1.vim /etc/my.cnf 打开skip-grant-tables注解保存重启mysql 执行/etc/init.d/mysqld restart

2.设置root密码为空执行以下操作

/usr/local/mysql/bin/mysql -u root -p

use mysql;

update user set authentication_string='' where user='root';

exit

3.vim /etc/my.cnf 关闭skip-grant-tables，

4.重启/etc/init.d/mysqld restart

5.免密码登录执行mysql -u root -p直接回车

6.使用 ALTER 修改 root 用户密码

ALTER user 'root'@'localhost' IDENTIFIED BY '123456';

完成密码修改