Getting error mysql_connection.cpp:1151:handler(): [ERROR] Failed to mysql_real_connect() on 20:10.38.2.5:3306 , FD (Conn:155 , MyDS:155) , 1045: Access denied for user 'appuser3'@'10.40.0.24' (using password: YES).

[avanigargg]

Hi,

I have deployed proxysql on GKE and I am using proxysql to connect to cloudsql(mysql) database.
I have created a user appuser3@'%'.
When I login through mysql client to proxysql, I am able to get the query result.
But for load simulation, I am using mysqlslap client, Through which I am not able to connect to the proxysql and it is giving error like my user 'appuser3' does not have access on the GKE host.

Below is the error

mysql_connection.cpp:1151:handler(): [ERROR] Failed to mysql_real_connect() on 20:10.38.2.5:3306 , FD (Conn:155 , MyDS:155) , 1045: Access denied for user 'appuser3'@'10.40.0.24' (using password: YES).