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

当尝试使用MySQL命令修改root用户的密码时，如果遇到ERROR1133错误，表示找不到匹配的用户记录。解决方法是检查数据库中user表的Host字段，确保命令中的'localhost'与该字段值一致。如果Host为'%', 则修改命令为set password for 'root'@'%' = password('新密码'); 执行后刷新权限，用flush privileges; 命令即可完成密码修改。

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

<span style="color:#000000"><span style="background-color:#1d1f21"><code class="language-java">set password <span style="color:#b294bb">for</span> root<span style="color:#999999">@localhost</span><span style="color:#a67f59">=</span><span style="color:#81a2be">password</span><span style="color:#999999">(</span><span style="color:#b5bd68">'你的密码'</span><span style="color:#999999">)</span><span style="color:#999999">;</span> 
或者 
set password <span style="color:#b294bb">for</span> <span style="color:#b5bd68">'root'</span>@<span style="color:#b5bd68">'localhost'</span><span style="color:#a67f59">=</span><span style="color:#81a2be">password</span><span style="color:#999999">(</span><span style="color:#b5bd68">'MyNewPass4!'</span><span style="color:#999999">)</span><span style="color:#999999">;</span> 
</code></span></span>

AI写代码java

运行

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

解决：

<span style="color:#000000"><span style="background-color:#1d1f21"><code class="language-java">use mysql<span style="color:#999999">;</span>
select Host<span style="color:#999999">,</span>User from user<span style="color:#999999">;</span>
</code></span></span>

AI写代码java

运行

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

<span style="color:#000000"><span style="background-color:#1d1f21"><code class="language-java">set password <span style="color:#b294bb">for</span> <span style="color:#b5bd68">'root'</span>@<span style="color:#b5bd68">'%'</span><span style="color:#a67f59">=</span><span style="color:#81a2be">password</span><span style="color:#999999">(</span><span style="color:#b5bd68">'MyNewPass4!'</span><span style="color:#999999">)</span><span style="color:#999999">;</span>
</code></span></span>

AI写代码java

运行

• 刷新

<span style="color:#000000"><span style="background-color:#1d1f21"><code class="language-java"> flush privileges<span style="color:#999999">;</span>
</code></span></span>

AI写代码java

运行