Mysql 8 修改root密码

sudo mysql -uroot -p
#使用sudo之后mysql密码为空即可登陆

use mysql;
update user set authentication_string='' where user='root';
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

或者

ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('new_password');