--设置密码类型
update mysql.user set plugin='mysql_native_password' where user='root';
--修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
【MYSQL】实用语句(持续更新)
于 2021-12-17 15:05:18 首次发布
--设置密码类型
update mysql.user set plugin='mysql_native_password' where user='root';
--修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';