I have two mysql test servers set up; 10.10.51.2 and 10.10.51.3.
They aren’t replicating or anything they are just regular old default mysql servers.
I can connect to either of them from the first one by using
with ‘test’ being the database I want to connect to. This works for both 10.10.51.2 and 10.10.51.3 same password and everything.
I want to sync the ‘TEST’ table in the ‘test’ database using pt-table-sync. I type in the following which I think should work:
I get back:
DBI connect(‘test;host=10.10.51.3;mysql_read_default_g roup=client’,‘root’,…) failed: Access denied for user ‘root’@‘10.10.51.2’ (using password: YES) at /bin/pt-table-sync line 2220
I feel like it has something to do with the login @ host combo but I’m unsure what to do about it.
edit: fixed P for port to cap.