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