在mysql5.7中主要按照以下方式
use mysql;
select host,user from user;
update user set authentication_string=PASSWORD('ok') where User='root';
update user set plugin="mysql_native_password"; 必须要加否则修改不成功
flush privileges;
exit;
在mysql5.7中主要按照以下方式
use mysql;
select host,user from user;
update user set authentication_string=PASSWORD('ok') where User='root';
update user set plugin="mysql_native_password"; 必须要加否则修改不成功
flush privileges;
exit;