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?