Couldn't execute 'FLUSH TABLES': Access denied
Just tried to sync my production Drupal database to my local machine with the drush sql-sync command and I got the following error message: 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).