Not the answer you need?
Register and ask your own question!

pt-table-sync can't connect

cperishocperisho EntrantCurrent User Role Beginner
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.

Comments

  • cperishocperisho Entrant Current User Role Beginner
    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?
  • mirfanmirfan Database Administrator Inactive User Role Beginner
    Try single quotes around password and check if it works.
    Example:
    Password: !123

    Try it with "!123"
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.