Scenario 1 with ID testuser: Updated the application configuration to connect to database through maxscale (UserID & Password not changed, only IP/SLB) - Intermittent Access Denied Issue

Scenario 2 with ID testuser: Updated the application configuration to connect to database directly i.e Master Server xxx.xxx.xxx.xxx (UserID & Password not changed, only IP/SLB) - No Issue

Scenario 3 with ID testuser02: Updated the application configuration to connect to database through maxscale (UserID & Password not changed, only IP/SLB) - Intermittent Access Denied Issue

Scenario 4 with ID testuser02: Updated the application configuration to connect to database directly i.e Master Server xxx.xxx.xxx.xxx (UserID & Password not changed, only IP/SLB) - No Issue

mysql -h <Master-IP> -testuser02 -p -P 6603

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 6170995

Server version: 10.2.14-MariaDB-log MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

-sh-4.2$ mysql -h <slave-IP> -testuser02 -p -P 6603

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 343111

Server version: 10.2.14-MariaDB-log MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

2020-02-05 20:20:55   notice : syslog logging is enabled.

2020-02-05 20:20:55   notice : maxlog logging is enabled.

2020-02-05 20:20:55   notice : Using up to 4.69GiB of memory for query classifier cache

2020-02-05 20:20:55   notice : Working directory: /maxscale/logs/maxscale_logs

2020-02-05 20:20:55   notice : The collection of SQLite memory allocation statistics turned off.

2020-02-05 20:20:55   notice : Threading mode of SQLite set to Multi-thread.

2020-02-05 20:20:55   notice : MariaDB MaxScale 2.4.6 started (Commit: 714dece7ddb025d2ed2cca945a607a02b80bc7a2)

2020-02-05 20:20:55   notice : MaxScale is running in process 104967

..

.....

........

2020-02-11 13:28:14   warning: (218168) [MariaDBAuth] ReadWriteMasterService: login attempt for user 'XXXXXX'@[XX.XX.XXX.XXX]:XXXXX to database 'XXXX', authentication failed. Wrong password.