Host '192.168.83.72' is not allowed to connect to this MySQL server
时间: 2023-12-23 14:43:08 浏览: 30
报错信息"Host '192.168.83.72' is not allowed to connect to this MySQL server"表明192.168.83.72这个主机被禁止连接到MySQL服务器。
解决这个问题的方法是通过在MySQL服务器上进行设置来允许该主机连接。可以按照以下步骤进行操作:
1. 首先,登录到MySQL服务器。可以使用以下命令登录MySQL:
2. 在MySQL命令提示符下,输入以下命令来授权该主机连接:
```
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.83.72' IDENTIFIED BY 'your_password';
```
其中,'root'是MySQL的用户名,'192.168.83.72'是被授权的主机IP地址,'your_password'是MySQL的密码。根据实际情况进行相应的替换。
3. 然后,刷新MySQL的权限设置,使更改生效:
```
FLUSH PRIVILEGES;
```
现在,您应该能够使用"192.168.83.72"这个主机成功连接到MySQL服务器了。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [linux mysql 5.7](https://blog.csdn.net/qq_25713179/article/details/80940876)[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: 33.333333333333336%"]
- *2* [Linux centors7.5 安装MySQL5.7](https://blog.csdn.net/u012798558/article/details/83026833)[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: 33.333333333333336%"]
- *3* [undefined](undefined)[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: 33.333333333333336%"]
[ .reference_list ]