On 4/1/24 12:57, Marc via discuss wrote:
I don't want to have this limit on ip but on ip+database, how can I change this?
at the point at which connections are blocked the database the remote host wants to use is not even known yet, so this blocking mechanism can't take it into account. The related setting is max_connect_errors, but as far as I can tell it defaults to 100 for all MariaDB releases, and for MySQL, too, at least back to MySQL 5.7 https://mariadb.com/kb/en/server-system-variables/#max_connect_errors https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_... That's why I was asking for specific version information on a previous reply ... PS: your quoting style is confusing, the ">" indentation marker is supposed to mark quoted text, one ">" per level of quoting, not your actual reply. -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) MariaDB Corporation | http://www.mariadb.com/