Hi.I'm following Jake's video on setting up a replicating toaster setup, and have hit a pretty solid brick wall, and can't figure out how to get around it.
I have the 2 MySQL servers setup, and running. Replication seems to be working fine in one direction, but not in the other.
The slave thread on server1 fails with this error:140411 15:02:27 [ERROR] Slave I/O thread: error connecting to master 'mail1_user@192.168.64.4:3306': Error: 'Access denied for user 'mail1_user'@'mail.avits.ca' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400
I know the grants on server2 are setup on the target database. I have tried specific IP address and wildcard, and neither has worked.
mysql> show grants for "mail1_user"; +----------------------------------------------------------------------------------------------+ | Grants for mail1_user@% | +----------------------------------------------------------------------------------------------+| GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'%' IDENTIFIED BY PASSWORD 'blah' |
+----------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> show grants for "mail1_user"@"192.168.0.4"; +--------------------------------------------------------------------------------------------------------+ | Grants for mail1_user@192.168.0.4 | +--------------------------------------------------------------------------------------------------------+| GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'192.168.0.4' IDENTIFIED BY PASSWORD 'blah' |
+--------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)I can connect using the MySQL client as the use mail1_user and that password with no issues.
Thoughts, suggestions? Thanks, Richard. -- Alberni Valley IT Services
<<attachment: richard.vcf>>
--------------------------------------------------------------------- To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com