Access denied for user 'GRID_TEST_WH'@'10.130.108.50' (using password: YES)

Access denied for user 'GRID_TEST_WH'@'10.130.108.50' (using password: YES)这个错误提示意味着用户'GRID_TEST_WH'在IP地址为10.130.108.50的主机上使用了错误的密码，导致无法访问数据库。为了解决这个问题，你可以按照以下步骤进行操作:

1. 首先，进入服务器终端并使用以下命令登录到MySQL数据库:
mysql -u root -p

2. 输入root用户的密码以登录。

3. 接下来，使用以下命令选择数据库:
use mysql;

4. 使用以下命令查询用户'GRID_TEST_WH'的连接权限:
select user, host from user where user = 'GRID_TEST_WH';

5. 如果查询结果显示该用户只允许在本地连接，而你需要允许远程连接，则需要使用以下命令修改用户的连接权限:
update user set host = '%' where user = 'GRID_TEST_WH' and host = 'localhost';

6. 确认更改已生效，可以再次运行以下命令查询用户的连接权限:
select user, host from user where user = 'GRID_TEST_WH';

7. 最后，刷新权限表以使更改生效:
flush privileges;

通过以上步骤，你应该可以解决Access denied for user 'GRID_TEST_WH'@'10.130.108.50' (using password: YES)的问题。如果问题仍然存在，你可以尝试重启MySQL服务并再次尝试连接。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [mysql Access denied for user ‘root’@’localhost’ (using password: YES)解决方法](https://download.csdn.net/download/weixin_38624557/12830607)[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: 33.333333333333336%"]
- *2* [Access denied for user ‘root‘ @‘123.233.244.218‘(using password:YES)的解决方法](https://blog.csdn.net/qq_34137397/article/details/128216182)[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: 33.333333333333336%"]
- *3* [Mysql客户端连接服务端提示“Access denied for user ‘user_name‘@‘xxx.xxx.xx.xx‘ (using password: ...](https://blog.csdn.net/qq_39930963/article/details/116261935)[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: 33.333333333333336%"]
[ .reference_list ]