How Can I Grant SUPER Privileges in MySQL?

Assigning SUPER Privileges to MySQL Database

Problem

When attempting to execute the query SET GLOBAL log_bin_trust_function_creators = 1, the following error occurs: #1227 - Access denied; you need the SUPER privilege for this operation. How can SUPER privileges be assigned to a MySQL database?

Solution

Using phpMyAdmin:

1. Navigate to phpMyAdmin's Privileges tab.
2. Click Edit User.
3. Under the Administrator tab, select the SUPER checkbox.
4. Click Go.

Using MySQL Console:

1. Execute the following query:

   mysql> GRANT SUPER ON *.* TO user@'localhost' IDENTIFIED BY 'password';

   Copy after login

   Replace user with the username and password with the user's password.

2. End the session with FLUSH PRIVILEGES;.

   mysql> FLUSH PRIVILEGES;

   Copy after login

Note: It is recommended to grant SUPER privileges with *.* (all databases) instead of a specific database, as SUPER is a global privilege.

The above is the detailed content of How Can I Grant SUPER Privileges in MySQL?. For more information, please follow other related articles on the PHP Chinese website!