Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using pt-table-checksum for the first time and have some questions that I can't seem to resolve by reading the documentation on Percona's website.

Per the documentation, pt-table-checksum performs an online replication consistency check by executing checksum queries on the master. Does this script have to be run on the master? Can I run from another server that has no MySQL installed? I tried this:

pt-table-checksum --host=mysqlistance --user=user --password=password --replicate-check-only

But I get some errors indicated that it is unable to connect to the localhost. However, it specifies the IP instead of localhost.

share|improve this question
What exactly is the error you are getting? – Derek Downey May 16 '12 at 17:19

You need to use a mysql user that has permissions from the host your executing the script from.

Run select user, host from mysql.user on the database to see if your user has an entry for the IP you're connecting from. If not, you will have to grant permissions to the user for that host.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.