Due to this error, mysql user is unable to login with user monitor@localhost
# This script will assist with configuring ProxySQL for use with
# Percona XtraDB Cluster (currently only PXC in combination
# with ProxySQL is supported)
#
# ProxySQL read/write configuration mode is singlewrite
#
# Configuring the ProxySQL monitoring user.
# ProxySQL monitor user name as per command line/config-file is monitor
#
# The monitoring user is already present in Percona XtraDB Cluster.
#
# ERROR 1045 (28000): Access denied for user 'monitor'@'localhost' (using password: YES)
# ERROR (line:1297) : Failed to connect to Percona XtraDB Cluster using monitor credentials.
# -- Please check MONITOR_USERNAME and MONITOR_PASSWORD
It is noticed that the below mentioned pipeline job are failing due to by default ipv6 enabled in Jenkins worker machines
https://pxc.cd.percona.com/job/qa-proxysql2-pipeline/
https://pxc.cd.percona.com/job/qa-proxysql2-pipeline-mohit/
Due to this error, mysql user is unable to login with user monitor@localhost
# This script will assist with configuring ProxySQL for use with # Percona XtraDB Cluster (currently only PXC in combination # with ProxySQL is supported) # # ProxySQL read/write configuration mode is singlewrite # # Configuring the ProxySQL monitoring user. # ProxySQL monitor user name as per command line/config-file is monitor # # The monitoring user is already present in Percona XtraDB Cluster. # # ERROR 1045 (28000): Access denied for user 'monitor'@'localhost' (using password: YES) # ERROR (line:1297) : Failed to connect to Percona XtraDB Cluster using monitor credentials. # -- Please check MONITOR_USERNAME and MONITOR_PASSWORD