AUTH_RESULT

[fengbaoli]

数据连接正常，后端的端口也是连接了mysql，但是日志里面报错 AUTH_RESULT，使用的shard的，查询直接无法使用，本来想用cetus去替代mycat
(pid=339117) 2025-07-16 18:53:37: (warning) src/network-mysqld.c:5435: con:0x12fca80 failed for server:0x1322000
(pid=339117) 2025-07-16 18:53:37: (warning) src/network-mysqld.c:5318: error send AUTH_RESULT: ffffffff
(pid=339117) 2025-07-16 18:53:37: (warning) src/network-mysqld.c:5435: con:0x12fca10 failed for server:0x1245440
(pid=339117) 2025-07-16 18:53:37: (warning) src/network-mysqld.c:5318: error send AUTH_RESULT: ffffffff
(pid=339117) 2025-07-16 18:53:37: (warning) src/network-mysqld.c:5435: con:0x12fc9a0 failed for server:0x131bd40
(pid=339117) 2025-07-16 18:53:37: (warning) src/network-mysqld.c:5318: error send AUTH_RESULT: ffffffff
(pid=339117) 2025-07-16 18:53:37: (warning) src/network-mysqld.c:5435: con:0x12fc930 failed for server:0x131bb00
(pid=339117) 2025-07-16 18:53:37: (warning) src/network-mysqld.c:5318: error send AUTH_RESULT: ffffffff
(pid=339117) 2025-07-16 18:53:37: (warning) src/network-mysqld.c:5435: con:0x12fc8c0 failed for server:0x131b8c0

[wangbin579]

Some accounts might not have the right permissions. It's best to capture network traffic to see which ones are being denied access.

[fengbaoli]

我已经给用户给了GRANT ALL PRIVILEGES ON . TO 'xxx'@'%';

[wangbin579]

The permissions set through middleware can be quite different from setting them directly in MySQL. So if you see an error, trust it — there’s usually something wrong behind it.