mysql修改密码

SET PASSWORD FOR ‘root‘@‘localhost‘ = PASSWORD(‘newpass‘);

use mysql;
select plugin from user where user = ‘root‘;
# 将指修改为默认值
update user set plugin=‘mysql_native_password‘;
# 修改密码
update user set authentication_string=password(‘root‘) where user=‘root‘ and host=‘localhost‘;
# 刷新权限
flush privileges;
# 修改密码
alter user ‘root‘@‘localhost‘ identified by ‘newPassword‘;