Running the Cluster Database Replication and Message: ERROR 1045 (28000): Access denied for user 'repluser'@'Your_Machine_Name' (using password: YES)

Document ID : KB000010901
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Customer is running the Cluster Database Replication and getting denied on repluser therefore not able to continue with the configurations.

Message: ERROR 1045 (28000): Access denied for user 'repluser'@'Your_Machine_Name' (using password: YES)

 

Background:

This error happen during the configuration, it the cluster setup ran more the once on the machine, it cold be the right for repluser was not laid down correctly.

The repluser was created under a different Hostname or used and IP address instead of Hostname and vice versa.

Trying the following:

[root@ssg91 bin]# ./create_slave.sh
--> For verbose output run with -v

Enter hostname or IP for the MASTER: 192.168.181.141
Enter replication user: [repluser]
Enter replication password: [replpass]
Enter MySQL root user: [root]
Enter MySQL root password: []
Do you want to clone a database from 192.168.181.141 (yes or no)? [no]

==> Error getting master status

Message: ERROR 1045 (28000): Access denied for user 'repluser'@'Your_Machine_Name' (using password: YES)

Environment:
This fix will work with all version of Gateway as long as they are using MYSQL has the Database.
Instructions:

Commands that need to be ran (in order on both nodes):

 

#DELETE FROM mysql.user WHERE user = "repluser";

#FLUSH PRIVILEGES;

 

# /opt/SecureSpan/Appliance/bin/add_slave_user.sh

 

You can follow the instructions states in the documentation

 

https://docops.ca.com/ca-api-gateway/9-1/en/install-configure-upgrade/configure-a-gateway-cluster/cluster-database-replication