SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
或者
update mysql.user set authentication_string=PASSWORD('newpwd') where User='root';
设置 validate_password_policy 的全局参数为 LOW 即可,
输入设值语句 “ set global validate_password_policy=LOW; ” 进行设值,
设置 validate_password_length 的全局参数为 6 即可
set global validate_password_length=6;
注释掉skip-grant-tables
flush privileges;
service mysqld restart