1130 - Host 192168.1.230' is not allowed to connect to this MySQL server
时间: 2023-09-27 22:09:18 浏览: 262
Host 主机名 is not allowed to connect the mysql server
这个错误意味着主机名为192.168.1.230的主机没有被授权连接到MySQL服务器。解决方法有以下步骤:
1. 在命令提示符(cmd)中运行mysql -u root -p,以使用root用户登录MySQL。如果提示“mysql 不是内部或外部命令”,请找到安装MySQL对应的bin文件夹,然后在该文件夹中运行mysql.exe命令。
2. 登录后,执行以下命令更新user表中的Host字段,将其修改为'%': update user set Host='%' where User='root';
3. 刷新权限,使更改生效:flush privileges;
这样,主机名为192.168.1.230的主机就能够连接到MySQL服务器了。请注意,如果出现其他错误提示,可以忽略。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [Host 主机名 is not allowed to connect the mysql server](https://download.csdn.net/download/weixin_38599712/14037862)[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_1"}}] [.reference_item style="max-width: 50%"]
- *2* *3* [Mysql报错:1130-host ... is not allowed to connect to this MySql server如何处理](https://blog.csdn.net/qq_41605893/article/details/127870539)[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_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
阅读全文