Comments on DBA Dojo: MySQL Error: error reconnecting to master

Thanks mate. Given this page ranks ok on Google h...

2011-02-02T02:58:28.330-08:00

Thanks mate.

Given this page ranks ok on Google hopefully others will find out about your resolution as well.

I found out that MASTER_PASSWORD has a maximum le...

2011-02-01T16:06:24.351-08:00

I found out that MASTER_PASSWORD has a maximum length of 32 characters for replication... although a 40-character password works fine for the manual logins and checks you'd run to troubleshoot replication.

@leBolide: It looks like you have systematically ...

2011-01-28T17:26:05.767-08:00

@leBolide:

It looks like you have systematically gone through most steps in trying to resolve the problem.

Try granting a replication slave user with the slave IP instead of hostname.

Test the connection from slave to master first using mysql.

Also check mysql.user on both the master and slave to make sure the hostnames are correct, and again after

I have an odd problem where replication should b...

2011-01-26T08:43:02.243-08:00

I have an odd problem where replication *should* be working, but it isn't.

Each MySQL server can ping the other by hostname and IP; a traceroute from either shows identical routes in opposite directions. These are CentOS, and I've turned off iptables and SELinux.

Connecting from the slave to the master:
mysql -u uk_slave_user --host ccukdb1.domain.int --port=

One thing to check, too -- check to see if replica...

2009-10-06T06:27:16.238-07:00