Mysql SUPER privileges

1227. “Access Denied; you need(at least one of) the SUPER privileges for this operation.


If you get this error in mysql, you just need to give the user more rights. So I recommend ssh’ing in to the server and just running the “mysql” command, then from there:

GRANT SUPER ON database.table_name TO mysql_user@’localhost’;
FLUSH PRIVILEGES;

Or if you just want to give the user Super user privileges on all databases:

GRANT SUPER ON *.* TO mysql_user@’localhost’;
FLUSH PRIVILEGES;

So the user should have the proper access after that.