mysqlsqlphpmyadmin

#1227 - Access denied; you need the SUPER privilege for this operation - how to solve?


I am trying to change a SQL Variable through phpMyAdmin, and I get this error:

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Access denied

Trying to solve this error has led me to this question here on StackOverflow. Unfortunately all of the proposed solutions do not seem to work for me:

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

As you can see from the screenshot above, there is no "privileges" tab in my phpMyAdmin.

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

When I try to execute code like this, I get further errors:

Access denied for user 'cpses_ajceej5cb1'@'localhost'

I have never heard of this cpses... user before, they certainly don't seem to exist anywhere. Here is a screenshot of the issue:

Access denied again

Given all of these set backs, how can I change a variable in phpMyAdmin?


Solution

  • In the end the only way I could edit these variables wasn't through phpMyAdmin at all - I had to alter them through cPanel.