Access denied for a user in ProxySQL

Hi there,
Iam not able to access the percona xtradb cluster 8.0.27.
The user ‘prpxc’ has all the privileges.

ProxySQLClient> show databases;
ERROR 1045 (28000): Access denied for user 'prpxc'@'ip-192-168-1-3(using password: YES).
1 Like

Run this:
SHOW GRANTS FOR 'prpxc'@'ip-192-168-1-3'; and verify the permissions. There is a big difference between users with hostnames vs users with IP addresses.

1 Like