mysql - Percona tool pt-table-sync -

continue access denied errors when running pt-table-sync on mysql databases holding tables pt-table-checksum found differences in replicated tables.

[mysql@node1:0 ~]$ pt-table-sync --execute --verbose master.com  slave.com -uroot -ppasswd dbi connect(';host=master.com;mysql_read_default_group=client','root',...)  failed: access denied user 'root'@'master.com' (using password: yes) @ /usr/bin/pt-table-sync line 2163 

running master server.

any ideas i'm doing wrong?

it must way tool connecting server. make sure symbols or other characters in password escaped. also, if connecting remote server, check see if root access enabled. check out this blog article how deal latter.

according mysql docs:

if following error, means using incorrect root password:

shell> mysqladmin -u root -pxxxx ver access denied user 'root'@'localhost' (using password: yes) if preceding error occurs when have not specified password, means have incorrect password listed in option file. try --no-defaults option described in previous item.

for information on changing passwords, see section 6.3.5, “assigning account passwords”.

if have lost or forgotten root password, see section c.5.4.1, “how reset root password”.

also perhaps helpful:

you can suppress use of option files client program invoking --no-defaults option. example:

shell> mysqladmin --no-defaults -u root version option files clients use listed in section 4.2.3.3, “using option files”. environment variables listed in section 2.13, “environment variables”.