时间:2021-07-01 10:21:17 帮助过:24人阅读
- /usr/local/mysql/bin/<span style="color: #000000;">mysql进入
- UPDATE user SET password</span>=PASSWORD(<span style="color: #800000;">"</span><span style="color: #800000;">newpassword</span><span style="color: #800000;">"</span>) WHERE user=<span style="color: #800000;">‘</span><span style="color: #800000;">root</span><span style="color: #800000;">‘</span><span style="color: #000000;">;
- FLUSH PRIVILEGES;
- </span><span style="color: #000000;"><br></span>
- <span style="color: #000000;"> 验证密码是否成功:
- </span><span style="color: #0000ff;"> select</span> user,host,password <span style="color: #0000ff;">from</span><span style="color: #000000;"> mysql.user;
- 是否有md5值</span>
mysql修改用户密码
标签:oca md5 where bsp sql table select new mysq