mysql 忘记root密码
时间: 2023-09-12 12:11:21 浏览: 62
如果你忘记了MySQL的root密码,可以通过以下步骤来重置密码。首先,你需要停止MySQL服务。然后,在MySQL配置文件(通常是/etc/my.cnf)中找到并注释掉skip-grant-tables这一行,保存并退出配置文件。接下来,启动MySQL服务。现在你可以以无密码的方式登录到MySQL。在MySQL命令行中执行以下命令来修改root用户的密码:update mysql.user set authentication_string=password('newpassword') where user='root'; (注意将newpassword替换为你想要设置的新密码)。然后,刷新权限以使修改生效:flush privileges; 最后,退出MySQL命令行并重新启动MySQL服务。现在你可以使用新设置的root密码登录到MySQL了。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [Mysql数据库 root用户密码忘记怎么办?](https://blog.csdn.net/CRMEB/article/details/117771509)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* *3* [MySQL忘记root密码(唯一好用的方法)](https://blog.csdn.net/u012154840/article/details/104375578)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]