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

Document ID : KB000115527
Last Modified Date : 28/09/2018
Show Technical Document Details
Question:
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) 
Answer:
<<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.