ERROR 1133 (42000): Can‘t find any matching row in the user table

解决 MySQL修改密码：ERROR 1133 (42000): Can’t find any matching row in the user table

set password for root@localhost=password('你的密码'); 
或者 
set password for 'root'@'localhost'=password('MyNewPass4!'); 

提示：命令修改mysql数据库root用户密码提示ERROR 1133 (42000): Can't find any matching row in the user table错误

解决：

use mysql;
select Host,User from user;

• 将set password for ‘root’@‘localhost’=password(‘MyNewPass4!’); 代码中的localhost修改%，与数据库Host字段值一致

set password for 'root'@'%'=password('MyNewPass4!');

• 刷新

 flush privileges;