We're updating the issue view to help you get more done. 

permission requirement for MySQL user is not correctly documented for hosted mysql

Description

User need lock tables permission which is not documented in plugin document :

If using a hosted option such as Amazon RDS or Amazon Aurora that do not allow a global read lock, table-level locks are used to create the consistent snapshot. In this case, you need to also grant LOCK_TABLES permissions to the user that you create. See Overview of how the MySQL connector works for more details.

otherwise below error will happen
org.apache.kafka.connect.errors.ConnectException: User does not have the 'LOCK TABLES' privilege required to obtain a consistent snapshot by preventing concurrent writes to tables.
at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:230) ~[1604698236276-0/:na]
at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:208) ~[1604698236276-0/:na]
at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:721) [1604698236276-0/:na]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_265]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_265]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_265]
Caused by: org.apache.kafka.connect.errors.ConnectException: User does not have the 'LOCK TABLES' privilege required to obtain a consistent snapshot by preventing concurrent writes to tables.
at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:350) [1604698236276-0/:na]
... 3 common frames omitted

Release Notes

None

Assignee

Sean Zhou

Reporter

Sean Zhou

Labels

None

Docs Impact

None

UX Impact

None

Components

Fix versions

Priority

Minor
Configure