mysql set password

mysql -u root -p

use mysql;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';   # 123456是密码，root是用户名

flush privileges;
quit;