Running the Cluster Database Replication and Message: ERROR 1045 (28000): Access denied for user 'repluser'@'Your_Machine_Name' (using password: YES)
Article ID: 10901
Updated On:
Products
Issue/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)
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.
[root@ssg91 bin]# ./create_slave.sh
--> For verbose output run with -v
Enter hostname or IP for the MASTER: 192.168.yyy.zzz
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.yyy.zzz (yes or no)? [no]
==> Error getting master status
Message: ERROR 1045 (28000): Access denied for user 'repluser'@'Your_Machine_Name' (using password: YES)
Environment
Resolution
Commands that need to be ran (in order on both nodes) from within the MySQL Database:
# DELETE FROM mysql.user WHERE user = "repluser";
# FLUSH PRIVILEGES;
Then run the following script:
# /opt/SecureSpan/Appliance/bin/add_slave_user.sh
You can follow the instructions states in the documentation
Feedback
