Drush sql-sync and civicrm issue
Civicrm utilises sql triggers for a number of purposes - including but not limited to populating values into the log_civicrm_% tables - if you have logging turned on under Admin -> System Settings -> Misc

You can't alter triggers. Easiest to dump the database then strip out triggers using the following perl 

perl -pi -e 's#\/\*\!5001[7|3].*?`[^\*]*\*\/##g' /path/to/mysqldump.sql


by way of Jon G and Chris Burgess on Why do I get &quot;Access denied; you need (at least one of) the SUPER privilege(s) for this operation&quot; when importing a SQL dump to CiviCRM?

after you import Civicrm will rebuild triggers as needed.