# Pt-table-checksum row

**URL:** https://forums.percona.com/t/pt-table-checksum-row/29064
**Category:** Percona Toolkit
**Created:** [March 11, 2024, 4:43am UTC](https://forums.percona.com/t/pt-table-checksum-row/29064 "2024-03-11T04:43:49Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![sslll](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sslll/32/15579_2.png) [@sslll](https://forums.percona.com/u/sslll)
#### Post date: [March 11, 2024, 4:43am UTC](https://forums.percona.com/t/pt-table-checksum-row/29064/1 "2024-03-11T04:43:49Z")

</div>

Tried running the pt-table-checksum with the --no-check-binlog-format, thought that using this flag would by-pass the need to set it as STATEMENT binlog format?

```auto
pt-table-checksum --recursion-method=dsn=t=percona.DSN_Table -u percona --ask-pass --no-check-binlog-format

03-11T04:38:51 Failed to /*!50108 SET @@binlog_format := 'STATEMENT'*/: DBD::mysql::db do failed: Access denied; you need (at least one of) the SUPER privilege(s) for this operation [for Statement "/*!50108 SET @@binlog_format := 'STATEMENT'*/"] at /usr/bin/pt-table-checksum line 10211, <STDIN> line 1.

This tool requires binlog_format=STATEMENT, but the current binlog_format is set to ROW and an error occurred while attempting to change it. If running MySQL 5.1.29 or newer, setting binlog_format requires the SUPER privilege. You will need to manually set binlog_format to 'STATEMENT' before running this tool.

```

Running pt-table-checksum 3.5.7

---

<div class="post-metadata">

### Author: ![Mughees\_Ahmed](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mughees_ahmed/32/9028_2.png) [@Mughees\_Ahmed](https://forums.percona.com/u/Mughees_Ahmed)
#### Post date: [March 11, 2024, 10:39am UTC](https://forums.percona.com/t/pt-table-checksum-row/29064/2 "2024-03-11T10:39:38Z")

</div>

> [@sslll](#):
>
> `setting binlog_format requires the SUPER privilege.`

Please check your grants , issue is with the grants.

---

<div class="post-metadata">

### Author: ![sslll](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sslll/32/15579_2.png) [@sslll](https://forums.percona.com/u/sslll)
#### Post date: [March 11, 2024, 2:16pm UTC](https://forums.percona.com/t/pt-table-checksum-row/29064/3 "2024-03-11T14:16:30Z")

</div>

Does the master require statement based replication? Currently my master + slaves are running statement based.

Is --[no]check-binlog-format only for bypassing configuration of statement based replication on the slaves?