The user running pt-table-sync has full access to the 2 databases:
GRANT ALL ON db1.* to test@localhost;
GRANT ALL ON db2.* to test@localhost;
The user does not have root access to the server, but he shouldn't need it because all he needs to do is run insert/update/delete queries to get the 2 tables in sync.
The user running pt-table-sync has full access to the 2 databases:
GRANT ALL ON db1.* to test@localhost;
GRANT ALL ON db2.* to test@localhost;
The user does not have root access to the server, but he shouldn't need it because all he needs to do is run insert/ update/ delete queries to get the 2 tables in sync.