mysql5.7 设置密码不生效的一种情况

select user,host,plugin from mysql.user;

mysql.user SET authentication_string=PASSWORD('1q!Qqqqq'), plugin='mysql_native_password' WHERE user='root';