...
This error is telling you that the slave is failing to connect to the master server.
Possible Solutions
Use GET_MASTER_PUBLIC_KEY clause
We can add GET_MASTER_PUBLIC_KEY = 1 to the CHANGE MASTER TO statement, and the connection succeeds.
This solution provided by this bug report in MySQL 8.
| Code Block |
|---|
STOP SLAVE; |
Issue the new CHANGE MASTER TO command
| Code Block |
|---|
CHANGE MASTER TO
MASTER_HOST='10.21.31.52',
MASTER_USER='blbackup',
MASTER_PASSWORD='passsword-goes-here',
GET_MASTER_PUBLIC_KEY = 1; |
Then restart and check the slave status.
| Code Block |
|---|
START SLAVE;
SHOW SLAVE STATUS; |
Connect Manually First
You might be able to solve this problem by creating a manual connection in a MySQL tool like Workbench. This solution provided by this documented bug in MySQL 8.
...