The Ultimate Guide to High Availability with MariaDB

Reset values of per user settings max_user _connections

Hello,

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!

Answer Answered by Ian Gilfillan in this comment.

Pre MariaDB 10.4, UPDATE mysql.user SET max_user_connections=0;

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.