mysql取消免密登录
时间: 2023-10-16 21:05:17 浏览: 45
取消MySQL的免密登录可以通过以下几个步骤完成:
1. 打开终端,输入以下命令登录MySQL:
```
mysql -u root -p
```
[1]
2. 输入密码登录MySQL。如果密码正确,你将成功登录到MySQL的命令行界面。
3. 在MySQL的命令行界面中,输入以下命令取消免密登录:
```
ALTER USER 'root'@'localhost' IDENTIFIED BY '';
```
这将把root用户的密码设置为空,从而取消免密登录。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [kali 取消mysql免密登录设置,mariadb10.5.8版本;进入MySQL,准确说是mariadb添加一条命令即可](https://blog.csdn.net/aqgzw/article/details/130295491)[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^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* [MySQL5.7安装教程,错误问题解决,免密登陆](https://blog.csdn.net/weixin_33362096/article/details/113289503)[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^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]