I am trying to execute query in mysql.
SET GLOBAL log_bin_trust_function_creators =1;
SET GLOBAL log_bin_trust_function_creators =1
#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
~ Asked on 2012-08-14 04:58:34
You can add super privilege using
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:
mysql> FLUSH PRIVILEGES;
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.
Then you can edit the user
~ Answered on 2012-08-14 05:29:38