Resolving the Access denied error when saving an SQL dump of a database from a Managed Service for MySQL® cluster using mysqldump
Written by
Updated at December 17, 2025
Issue description
When trying to save a dump using mysqldump, you get this error:
mysqldump: Couldn't execute 'FLUSH TABLES': Access denied;
you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation (1227)
Solution
Some mysqldump releases, starting from version 8.0.32, have a developer-confirmed bug: the --single-transaction option uses the FLUSH TABLES WITH READ LOCK command even if you do not specify the --flush-logs or --source-data keys in the utility startup options.
To fix this error, update your mysqldump to version 8.0.33 or higher.