MySql8修改root密码,修改用户名

补码 / 2023-05-22 / 原文

use mysql;
update user set authentication_string='' where user='root';    //  root设为空
ALTER user 'root'@'localhost' IDENTIFIED BY 'root';    //  root密码设为root
flush privileges;        //  刷新权限

 

use mysql;
update user set user =‘zk’ where user =‘root’;
flush privileges;        //  刷新权限