pt-table-sync can't connect

Polyglot Projects Percona Toolkit
1

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.

2

Never mind. There were some strange characters in my password that I wasn’t escaping properly. Still didn’t figure out how to escape a bang in a password, but changing the password to not include the ! fixed my issue…

Anybody know the proper way to escape a ! in a password?

3

Try single quotes around password and check if it works.
Example:
Password: !123

Try it with “!123”