MySQL Workbench Import failure -- You do not have the SUPER privilege

Asked Mar 13 '15 at 02:02

Active Mar 13 '15 at 02:02

Viewed 1,270 times

I have setup MySQL Workbench and linked to ClearDB in heroku. Upon attempting to import a schema, the error appears:

ERROR 1419 (HY000) at line 582: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Operation failed with exitcode 1

How can I add SUPER user privilege?

asked Mar 13 '15 at 02:02

Sauron

6,399
14
71
136

You might find this SO question useful: ["*how to add super privileges to mysql database?*"](http://stackoverflow.com/q/11946012/1364007). – Wai Ha Lee Mar 13 '15 at 02:05
What command that requires `SUPER` is on line 582? – eggyal Mar 13 '15 at 02:06

MySQL Workbench Import failure -- You do not have the SUPER privilege

0 Answers0