mysql导入超级权限_如何为mysql数据库添加超级权限？

I am trying to execute query in mysql.

SET GLOBAL log_bin_trust_function_creators =1;

Error:

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

解决方案

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 user@'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.