how to add super privileges to mysql database?


I am trying to execute query in mysql.

SET GLOBAL log_bin_trust_function_creators =1; 


SQL query:
SET GLOBAL log_bin_trust_function_creators =1
MySQL said:
#1227 - Access denied; you need the SUPER privilege for this operation

I want to know that how do i assign SUPER privileges to any database

This question is tagged with mysql

~ Asked on 2012-08-14 04:58:34

The Best Answer is


You can add super privilege using phpmyadmin:

Go to PHPMYADMIN > privileges > Edit User > Under Administrator tab Click SUPER. > Go

If you want to do it through Console, do like this:

 mysql> GRANT SUPER ON *.* TO [email protected]'localhost' IDENTIFIED BY 'password';

After executing above code, end it with:


You should do in on *.* because SUPER is not the privilege that applies just to one database, it's global.

~ Answered on 2012-08-14 05:02:06


You can see the privileges here.enter image description here

Then you can edit the user

~ Answered on 2012-08-14 05:29:38

Most Viewed Questions: