Greetings Ramesh,
Here’s my proxysql-admin.cnf:
[I]# proxysql admin interface credentials.
export PROXYSQL_DATADIR=‘/var/lib/proxysql’
export PROXYSQL_USERNAME=‘admin’
export PROXYSQL_PASSWORD=‘admin’
export PROXYSQL_HOSTNAME=‘localhost’
export PROXYSQL_PORT=‘6032’
PXC admin credentials for connecting to pxc-cluster-node.
export CLUSTER_USERNAME=‘admin’
export CLUSTER_PASSWORD=‘admin’
export CLUSTER_HOSTNAME=‘localhost’
export CLUSTER_PORT=‘3306’
proxysql monitoring user. proxysql admin script will create this user in pxc to monitor pxc-nodes.
export MONITOR_USERNAME=‘monitor’
export MONITOR_PASSWORD=‘monit0r’
Application user to connect to pxc-node through proxysql
export CLUSTER_APP_USERNAME=‘proxysql_user’
export CLUSTER_APP_PASSWORD=‘passw0rd’
ProxySQL read/write hostgroup
export WRITE_HOSTGROUP_ID=‘10’
export READ_HOSTGROUP_ID=‘11’
ProxySQL read/write configuration mode.
export MODE=“singlewrite”
ProxySQL Cluster Node Priority File
export HOST_PRIORITY_FILE=$PROXYSQL_DATADIR/host_priority.conf[/I]
And here’s the output of grep admin_credentials /etc/proxysql.cnf:
[root@node1 ~]# grep admin_credentials /etc/proxysql.cnf
admin_credentials=“admin:admin”
I couldn’t get them from the mysql client because when i try to connect to the mysql instance of proxysql on port 6032 i keep getting the error as described earlier.
@Lorraine: Sorry i didn’t mean to note that as a means of saying the percona team/community did not reply. Simply wanted to state that i tried asking elsewhere and did not receive any correct answers yet, so i was thinking it wasn’t a standard issue.
Thanks for the replies!
Regards,
Jeffrey