ProxySQL connection with Azure MySQL Single Server Instance

Question

Hi,

We are facing issue while connecting ProxySQL VM instance with Azure DB for MysQL Single Server instance on private endpoint.

The DB running instance shows status as "Stunned", instead of online.

The log indicates that the MySQL admin user name with @ extension (e.g. adminuser@primaryserver), used in the connection string-

mysql -u <USER_NAME> -p -h 127.0.0.1 --port=3306 <DATABASE_NAME>, is not supported.

Since ICMP is blocked on Azure Endpoint, we are unable to verify ping response to MySQL instance from ProxySQL.

I understand that username with @ extension is not supported by Azure MySQL DB Single Server instance.

Request your valuable inputs & support to this resolve this issue at the earliest.

Thanks.

Pranav

Answer 1

@Githa, Case ID 2303210030000926.