Creating a database dump fails
When using just
mysqldump db123 or
drush sql-dump you might see this error
mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need (at least
one of) the RELOAD privilege(s) for this operation (1227)
With newer versions of
mysqldump the MySQL team introduced the requirement of
privileges that we can’t provide since these provide admin level access in some
This is why you should adapt your commands as such:
mysqldump --no-tablespaces --column-statistics=0
drush sql-dump --extra-dump="--no-tablespaces --column-statistics=0"
We are looking into making this easier and provide a longterm fix as well.