pt-table-sync can't connect

  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-table-sync can't connect

    I have two mysql test servers set up; and
    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= --user=root --password=blarg test

    with 'test' being the database I want to connect to. This works for both and 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=,P=3306,u=root,p=blarg,D=test,t=TEST h=,P=3306,u=root,p=blarg,D=test,t=test

    I get back:

    DBI connect('test;host=;mysql_read_default_g roup=client','root',...) failed: Access denied for user 'root'@'' (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, 06: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?


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

      Try it with "!123"