Pt-table-sync permission

Hello,

What are the minimum permissions required to execute pt-table-sync? Is it necessary to have “all privileges”?

I’ve created a user with all privileges, is this a good practice?

mysql> show grants for ‘resync’@‘%’;
±-------------------------------------------+
| Grants for teste@% |
±-------------------------------------------+
| GRANT ALL PRIVILEGES ON . TO ‘resync’@‘%’ |
±-------------------------------------------+
1 row in set (0.00 sec)

1 Like