5 Replies Latest reply on Jan 2, 2017 6:05 AM by Vinit

error connecting to master - MySQL

Vinit Jan 2, 2017 6:50 AM

Hi All,

I have followed steps given in below document to set up Master Master replication in MySQL.

How to Set Up Master-Master Replication Using GTIDs In MySQL 5.7? (Doc ID 2199756.1)

I am getting below error when I execute 'SHOW SLAVE STATUS' on Server 1 and Server 2 -

error connecting to master 'repl2@[master1's host]:3306' - retry-time: 60 retries: 9

Please can you advice me on this.

Regards,

Vinit

1. Re: error connecting to master - MySQL

Gbenga Ajakaye Dec 29, 2016 7:12 PM (in response to Vinit)

First, can you connect to your Master1?
Like Show 0 Likes(0)

Actions
2. Re: error connecting to master - MySQL

Fandy Dec 30, 2016 3:29 AM (in response to Vinit)

Could you provide more informations?
Error logs and which version are you use?
Like Show 0 Likes(0)

Actions
3. Re: error connecting to master - MySQL

Vinit Jan 2, 2017 5:16 AM (in response to Gbenga Ajakaye)

yes. I can.
Like Show 0 Likes(0)

Actions
4. Re: error connecting to master - MySQL

Vinit Jan 2, 2017 5:47 AM (in response to Fandy)

Server version: 5.7.17-log MySQL Community Server (GPL)
Like Show 0 Likes(0)

Actions
5. Re: error connecting to master - MySQL

Vinit Jan 2, 2017 6:05 AM (in response to Vinit)

Just to give you update.. When I am trying to connect to remote user (MASTER2) getting below error -

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -h 172.25.1.63 -u repl2 -pInfra#123 -P 3306 mydb

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
Like Show 0 Likes(0)

Actions