Description:
The agent needs the "SUPER" privilege for some operations, and it stays connected to the
monitored mysqld while running.
MySQL server has an option "max_connections" that is actually max_connections + 1 (super
privileged user)
This is so that when you reach max_connections, you can log in into the server using your
root user and either kill some connections or see what is going on.
But as the agent uses the super privilege, you cannot login into the server unless you
disconnect the agent or try something else.
How to repeat:
1- Install and start the agent and service manager
2- Set the max_connections=2 on your monitored mysqld
3- start your monitored mysqld
4- Using the mysql command line client, start another connection to the mysqld server
5- Try to start again a new connection, you would get an error and you will not be able
to login into the mysql server, even using the root user.
