'Configuring proxysql as a load balancer for mysql on ubuntu

I am trying to use PoxySQL as Load Balancer for mySQL on ubuntu 20.04

I created 3 servers and created a group replication I created a user named playgrounduser from machine 1 and GRANT ALL PROVILEDGES to playgrounduser, now I went back to my proxysql and written:

mysql -u playgrounduser -p -h 127.0.0.1 -P 6033 --prompt='ProxyClient> '

then i try to issue a query example ProxySQLClient> SELECT @@hostname; the following error is appearing:

Error 1045(28000): Access denied for user 'playgrounduser'@'192.168.70.55' (using password: YES)
mysqlproxyproxysql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions