How to solve RDS MySQL - FLUSH TABLES WITH READ LOCK: Access denied for user when running mysqldump

Опубликовано: 29 Сентябрь 2024
на канале: Ambar Hasbiyatmoko
425
2

How to solve error when executing mysqldump on RDS MySQL:

mysqldump: Couldn't execute 'FLUSH TABLES WITH READ LOCK': Access denied for user 'user'@'%' (using password: YES) (1045)

solution:
just add parameter: --set-gtid-purged=OFF on mysqldump.