APIGateway failed in cluster configuration of the appliance - ERROR 1045 (28000): Access denied

Products

• STARTER PACK-7
• CA Rapid App Security
• CA API Gateway

Issue/Introduction

The following error may appear when add_slave_user.sh is run.
Message: mysql: [Warning] Using a password on the command line interface can be insecure. 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 

Reproduction procedure:
Run add_slave_user.sh 
But it failed with error 

/opt/SecureSpan/Appliance/bin/add_slave_user.sh 
--> For verbose output run with -v 

Gathering information for SLAVE user 
Enter hostname or IP for the SLAVE: STOdhd-436 
Enter replication user: [repluser] repluser 
Enter replication password: [replpass] 
Enter MySQL root user: [root] root 
Enter MySQL root password: [] 

Checking configuration of running MySQL... 

==> Error getting variables 

Message: mysql: [Warning] Using a password on the command line interface can be insecure. 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 

Environment

Release:
Component: APIGTW

Resolution

<<Message: mysql: [Warning] Using a password on the command line interface can be insecure.
<<ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES)

The above error occurs mainly when you specify a password other than 7 layer for root password.
Please specify 7 layer for the root password.