Adding MySQL Instance with Super Privilege Error

MySQL Super Privilege Error

When adding an instance for MySQL 5.0 or over, you may encounter the following error:

This error happens when dbWatch Control Center is creating a user. This error appears indicating that the user has no super privilege rights.

There are two methods in dealing with the problem. First, we’ll do it using the commandline. Second, we’ll do it using any management tool available.

Command Line

Open your windows command line and go to your MySQL directory. Open MySQL and input the user name and password. This should open up MySQL.
Afterwards, input the following query:

SET GLOBAL log_bin_trust_function_creators = 1;

This sets the variable log_bin_trust_function_creators to ON.

Then exit the MySQL but input ‘exit’.

Using a management tool

Open your SQL workbench or any management tool you are using.

Same as before, you want to input the same query:

SET GLOBAL log_bin_trust_function_creators = 1;

But this time, we’ll add a way to see the variable:

SHOW VARIABLES LIKE 'log_bin_trust_function_creators';

*To turn it off, simple exceute the following query: SET GLOBAL log_bin_trust_function_creators = 0;

Add Instance Successful

Once you completed one of the previous steps, you should be able to successfully add a MySQL Instance. Add that MySQL Instance and you should be able to see the following:

← Backup of dbWatch / Restore configuration backup →