how to add super privileges to mysql database?

Question

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

Accepted Answer

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 it with `*.*` (all databases) because SUPER is not a privilege which applies just to one database, it's global.

how to add super privileges to mysql database?

Solution

Problem