"Host 'node1' is not allowed to connect to this MySQL server"

根据引用\[1\]和引用\[2\]的信息，你遇到的问题是在通过go语言程序连接MySQL时出现了"Host is not allowed to connect to this MySQL server"的错误。这个错误意味着远程连接被拒绝，只有本地连接是允许的。

根据引用\[3\]的信息，你可以通过以下步骤解决这个问题：
1. 打开命令提示符(cmd)并进入到PHP的bin文件夹（如果系统环境变量已经配置好，可以忽略这一步）。
2. 依次执行以下命令：
- mysql
- use mysql
- select host, user from user

执行完以上命令后，你将会看到一个类似下面的结果：
+-----------+---------------+
| host | user |
+-----------+---------------+
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+-----------+---------------+
3 rows in set (0.00 sec)

这个结果显示了数据库中mysql表中的权限设置。如果你看到"Host 'node1' is not allowed to connect to this MySQL server"，那么说明在这个表中没有允许'node1'主机连接到MySQL服务器的权限。

为了解决这个问题，你可以执行以下命令来添加允许'node1'主机连接的权限：
- GRANT ALL PRIVILEGES ON *.* TO 'root'@'node1' IDENTIFIED BY 'your_password' WITH GRANT OPTION;
- FLUSH PRIVILEGES;

请确保将'your_password'替换为你的MySQL密码。

通过执行以上步骤，你应该能够解决"Host 'node1' is not allowed to connect to this MySQL server"的问题。
#### 引用[.reference_title]
- *1* [Host is not allowed to connect to this MySQL server解决方法](https://blog.csdn.net/qq_40309341/article/details/121464853)[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^control_2,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [连接MySQL出现Host is not allowed to connect to this MySQL server 解决方法](https://blog.csdn.net/arlene12345/article/details/122933316)[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^control_2,239^v3^insert_chatgpt"}} ] [.reference_item]
- *3* [message from server: “Host is not allowed to connect to this MySQL server“问题的解决办法](https://blog.csdn.net/Julia_up/article/details/126776244)[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^control_2,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]