One of your colleagues is trying to make a change using the mysql command-line client for his or her application session.
The colleague instant messages you this command:
mysql> SET SESSION max_connections = 200;
Why does the command fail?
max_connections requires the GLOBAL scope.
Its current user does not have the SUPER privilege.
max_connections is not a dynamic variable. You need to change the config file and restart the database.
Users can control only the max_user_connections variable.
Submit