Drush sql-sync: Access denied; you need the SUPER privilege for this operation I am trying to use drush to move my live database down to my dev database. I am doing 

drush sql-sync @live @devel --sanitize


However I get the error:


  "ERROR 1227 (42000) at line 1478250: Access denied; you need the SUPER privilege for this operation"


I think it is due to the views in the db from uc_views module, is there any way around this?

I also tried to do 

drush sql-sync --skip-tables-key uc_views @live @devel --sanitize


where uc_views is an option declared in drushrc.php with an array of the db views from uc_views, but to no avail.
Here is my drushrc.php

$options['skip-tables']['uc_views'] = array('uc_order_products_pair_vw', 'uc_order_products_qty_vw', 'uc_order_products_user_vw');


I would actually prefer to copy the database views from uc_views rather than exclude them if that is possible.
The user defined in settings.php on one or both sides of the sync lacks the SUPER privilege on the database.

Log in as the mysql root user and do

GRANT SUPER ON [db_name] TO '[username]'@'localhost' IDENTIFIED BY '[password]';


If you are security-conscious (as you should be), it's worth taking the following into account: 


  Do not grant the PROCESS or SUPER privilege to nonadministrative users. The output of mysqladmin processlist and SHOW PROCESSLIST shows the text of any statements currently being executed, so any user who is permitted to see the server process list might be able to see statements issued by other users such as UPDATE user SET password=PASSWORD('not_secure').