Announcement

Announcement Module
Collapse
No announcement yet.

pt-table-sync can't connect

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-table-sync can't connect

    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

    mysql --host=10.10.51.2 --user=root --password=blarg test

    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:

    pt-table-sync --dry-run h=10.10.51.3,P=3306,u=root,p=blarg,D=test,t=TEST h=10.10.51.2,P=3306,u=root,p=blarg,D=test,t=test

    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

    Confused. What am I missing?
    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.
    Last edited by cperisho; 11-13-2013, 05:03 PM.

  • #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?

    Comment


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

      Try it with "!123"

      Comment

      Working...
      X