Reset values of per user settings max_user _connections
when doing a lookup with: SELECT User, Host, max_connections, max_user_connections FROM mysql.user;
We have several users in that list with a non cero value for max_user_connections. Would like to know if there is any command to globally set those values to 0. I already tried with: SET GLOBAL max_user_connection=0;
But getting this error: ERROR 1290: The MariaDB server is running with the --max-user-connection=0 option so it cannot execute this statement
It would be good to have general command to do that, to not having to edit each entry by its own. Thanks for any help!