1130- Host '180.1 62.107.17' is not allowed to connect to this MySQL server
时间: 2023-09-08 10:13:15 浏览: 49
这个错误提示是因为主机'180.162.107.17'没有被允许连接到MySQL服务器。这种情况通常是由于数据库只允许本地连接访问所导致的。你可以通过修改MySQL服务器中的'user'表中的权限来解决这个问题。首先,在命令行界面中连接到数据库服务器,使用以下命令:mysql -u root -p \[2\]然后,进入到mysql数据库,并修改'user'表中的'host'项,将其从'localhost'改为'%'。最后,刷新权限以使更改生效,使用以下命令:flush privileges; \[1\]这样,你就可以允许主机'180.162.107.17'连接到MySQL服务器了。
#### 引用[.reference_title]
- *1* [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^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [navicat连接数据库报错:1130-host ‘..‘ is not allowed to connect to this MySql server解决方法](https://blog.csdn.net/weixin_44880442/article/details/121963695)[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^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *3* [解决Navicat 报错:1130-... is not allowed to connect to this MySql server,MySQL不允许从远程访问的方法](https://blog.csdn.net/weixin_42471823/article/details/113477414)[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^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]