AnsweredAssumed Answered

create slave access denied error.

Question asked by Popleys on Aug 31, 2017
Latest reply on Jan 12, 2018 by fazab01

Hi There, Am getting the below exception while creating slave,the error is highlighted below. please advice.

 

[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'@'192.168.181.136' (using password: YES)

 

Prior to running above create slave, i have ran the below:


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


Gathering information for SLAVE user

You must enter a SLAVE
Enter hostname or IP for the SLAVE: 192.168.181.141
Enter replication user: [repluser]
Enter replication password: [replpass]
Enter MySQL root user: [root]
Enter MySQL root password: []

Checking configuration of running MySQL...
MySQL appears to be properly configured with server_id=1
Do you want to continue? [Y] y
Granting slave permissions to repluser@192.168.181.141
Done.

 

Note: ssg version: 9.1 and prior to running above scripts i have created an database with name ssg.

 

Thanks

Outcomes