Forums

No SUPER user in MySQL

I want to kill connections in MySQL however whenever I run commands in the MySQL console for example:

SET GLOBAL max_user_connections=100;

I get the following error:

ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation

However when I loop up the users It only shows one and the level is "USAGE" and there isn't a root user. How can I get a user with SUPER privileges?

Convert to list

Super User is hidden

You don't have admin / super user privileges on MySQL.