3、ROOT用户操作
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'abc@123'; #修改root密码
alter user 'root'@'localhost' identified by 'newpassword';
FLUSH PRIVILEGES;
update user set host='%' where user = 'root'; #修改root用户允许任何ip都可以远程登录
ALTER USER 'root'@'%' IDENTIFIED BY 'abc@123' PASSWORD EXPIRE NEVER; #修改root密码永不过期
FLUSH PRIVILEGES;
网友评论