[TriLUG] MySQL Replication

[Brian McCullough]

On Thu, Jan 29, 2015 at 05:40:05PM -0500, Brian McCullough wrote:
> On Thu, Jan 29, 2015 at 04:10:39PM -0500, matt at noway2.thruhere.net wrote:
> > Interesting.
> > 
> > It looks like that is turned off by default in the my.cnf file (/etc/mysql).

In my case, I have an entry in the my.cnf file for an error.log, but it
just didn't seem to be collecting any records at the time.



> > I think the previous suggestion of adding a user 'user'@'ip address' or
> > 'user'@'%' is the way to go around this problem.
> 
> Which I had already done.  However, ( silly me ), I had changed the
> remote password to something other than the local password, so I was
> misleading myself with spurious errors.
> 
> 
> > From the fact that you can login with this user at localhost, I am all but
> > positive this is your issue.

One thing that I should point out.

"slave_user" is not the "test_user" that I was using to log in remotely.
"slave_user" only has "Replication Slave" permissions in the Master
machine.  


OK, this is weird.

Just for fun, I tried logging in as slave_user, remotely.

I received the following responses:

root at slave:~# mysql -u test_user -p -h master
Enter password: 
( successful login to mysql )
root at slave:~# mysql -u test_slave -p -h master
Enter password: 
ERROR 1045 (28000): Access denied for user 'test_slave'@'slaveip' (using password: YES)

Let me rebuild the user record.  Maybe the password is wrong.


Success!!  OK. I must have mistyped the password when I originally
created the slave user.


Thank you, All.


Now I have to work on how to handle the fact that the tables in the two
different machines have different table names.




Brian