Fixer Fixer - 24 days ago 10
MySQL Question

Access denied; you need the SUPER privilege for this operation - MySQL

I have my user

root
with all privileges on, I checked over and over and still show the same error, but wheren I try to change the value of the variable
max_user_connections
FROM
phpmyadmin
it display this error, in the plesk interface (I'm running a Windows server) where the list of user appear all the privileges of my user is enabled so I do not why this error.

But I ran this queries in
phpmyadmin


SHOW GRANTS;


enter image description here

SELECT USER();


enter image description here

SELECT CURRENT_USER();


I get
root@%


(Sorry but Stackoverflow says that I can't post images because of my reputation and no more than two links)

There is a difference between
root@localhost
and
root@%
?

And why in the first image the first line says
GRANT USAGE ON...
?

How I can give the
SUPER
privileges the user needs? thanks.

Answer

I didn't found a solution and nobody knew how to help me beyond to send me a manual with the definition of what SUPER means in MySQL so exploring all the files in my dedicated server and I found this path

C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\data\

I opened the my.ini file, I located the variable max_user_connections and I changed its value directly as I wanted, it solved my problem.