Comments - Reset values of per user settings max_user _connections

1 month, 1 week ago Ian Gilfillan

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

1 month, 1 week ago daniel l

Ian, thank you for your quick reply, worked perfectly! I guess its not a problem having root user set to 0 there as well. I defined max_user_connections with a higher number inside my.cnf.

The purpose of setting the limit is to find out, which user causes the DB to break every few days. When that happens, "Max_connections" value is on its limits, and its already set to 1024.

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.