pt-table-checksum - SQL Permossions

[Elazar_Gur]

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!

[mirfan]

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

mysql-master> GRANT REPLICATION SLAVE,PROCESS,SUPER, SELECT ON . TO checksum_user@‘%’ IDENTIFIED BY ‘checksum_password’;
mysql-master> GRANT ALL PRIVILEGES ON percona.* TO checksum_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/

[Deon_Joubert1]

@mirfan

GRANT REPLICATION SLAVE,PROCESS,SUPER, SELECT ON . TO checksum_user @’%’ IDENTIFIED BY ‘checksum_password’;

mysql-master> GRANT ALL PRIVILEGES ON percona.* TO checksum_user @’%’;

Thank you - I’ll use this to create a MySQL user @ localhost. That way I can safely use the user’s credentials in a crontab that will refresh checksums over weekends when our traffic is low.