pt-table-checksum - SQL Permossions

Hi,

I’m using pt-table-checksum in my environment, with the same SQL user to run the tool (with this command):

pt-table-checksum --ignore-databases mysql h=$masterHost,P=$masterPort,u=$slaveUser,p=$slavePass

What is the minimum but necessary Permission that the SQL user needs to run it?

Thanks!

You need the following privileges for the pt-table-checksum mysql user:

You may find my blogpost useful on this topic https://www.percona.com/blog/2015/08/12/mysql-replication-primer-with-pt-table-checksum-and-pt-table-sync/