ERROR 1045
Hi Forum.
I'm having some troubles regarding a setup on Replcation from Masters to Slave.
Both from replication and user I'm getting the same error.
I've controlled The user isn't expired. IU've recreated the user several times and grants the permissions but each time I'm getting the same error:
[ERROR] Slave I/O for channel 'Perform': error connecting to master 'mysql_replic@xxx.XXX.XXX.XXX:3306' - retry-time: 60 retries: 19, Error_code: 1045
I've got several masters und and running - I'm testing all firewall and telnet to the IP works fine.
All other slave channel are running but not this one. (I've got 9 channel running + this one) So I know my SSL cert etc is correct and working.
But I Cannot figure out this error.
just Saying
SLAVE_IO_Running: Connecting
SLAVE_SQL_RUNNING: Yes
I'm sure that the Master Has It's own unique ID - But cannot seem to find where this problem Lies.
On Master:
user deleted - and recreated with Replication rights:
mysql> SHOW GRANTS FOR 'mysql_replic'@'%'\G
*************************** 1. row ***************************
Grants for mysql_replic@%: GRANT REPLICATION SLAVE ON *.* TO 'mysql_replic'@'%'
I've allso changed % to the IP - Still same error
Sure that tcp/3306 is open and available
Verified unique ID
On Slave:
Reset the slave channel
Recreated the user ( but the user works with other masters)
Restartet the slave channel after updateing it
Verified unique ID
Still the same error
But I cannot login through Console to see any thing - gives me same error!
What to do from here
Subject
Views
Written By
Posted
ERROR 1045
6974
June 09, 2016 04:15AM
2490
June 09, 2016 09:32AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.