Unable to find variable : mysql-monitor_username in global_variables table in information_schema database in MySQL

[Mahendra Singh Bisht]

Hi team,

My ProxySQL setup is as follows:

Hostgroup1 : Master/Replica

Hostgroup2 : Replica

ProxySQL version : 1.4.12

I am following the article on https://proxysql.com/documentation/ProxySQL-Configuration/ for the initial configuration, however, I don't see the variable mysql-monitor_username in the global_variables table. The article says that we need to execute the update statement in the mysql database but I don't see that option existing already and I cannot make changes to the information_schema.global_variables table because basically that's a view.

Can someone please help me here in completing this step?

Also, while doing the Backend's health check, I am getting Access denied for user 'monitor'@'10.x.x.x' (using password: YES) even though the user monitor is present in the MySQL database and proxysql.

Reference Link : https://proxysql.com/documentation/ProxySQL-Configuration/

Regards,

MS

[Sanjaya Senadheera]

You need to run it in the proxy sql database. Not in the MySql database.

just connect to your local host from your ProxySql VM and execute it.

to connect to proxysql DB

mysql -u proxysqladmin -p -h 127.0.0.1 -P6032 --prompt='Admin> ' --default-auth=mysql_native_password

To see the variable

SELECT * FROM global_variables WHERE variable_name LIKE 'mysql-monitor_%';

[Mahendra Singh Bisht]

Hi Smsse,

The variables are in place when I checked in the ProxySQL, however, the documentation says that to create the user we need to connect to the MySQL. PFB screenshot from the article link that I shared earlier.

Regards,

MS

[Amit Rout]

Hello , Not sure if you have already resolved . But I think this way.

In ProxySQL ( SQLLite Database ) --> run the update global variables statement.

In MySQL Master ------------> It would be just create the monitor user ( ex- create user monitor identified by monitor ) and make sure both passwords are the same in both the places. 

Let me know if that helps.

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/proxysql/b3451136-2ed0-4cf8-a53f-7c561c81fe52n%40googlegroups.com.