maria-discuss team mailing list archive

[Staffan <solsson@xxxxxxxxx>]

Hi,

I've tried to change a user's max_connections after the limit has been
reached (connection attempts return "has exceeded the
'max_connections_per_hour' resource").

With MariaDB 10.2.18, running using the official docker image, we have
"select @@max_connections;" returning 100.

We have a user created "WITH MAX_CONNECTIONS_PER_HOUR 50".

Now if we bump in to this limit I fail to allow more connections by
increasing it. I've tried the following methods (using both 0 and a high
value):

ALTER USER 'site_devkit_live_index'@'%' WITH MAX_CONNECTIONS_PER_HOUR 0;

UPDATE mysql.user SET max_connections = 0 WHERE
user='site_devkit_live_index';
FLUSH PRIVILEGES;

GRANT USAGE ON *.* TO 'site_devkit_live_index'@'%'
  WITH MAX_CONNECTIONS_PER_HOUR 0;

The following indicates that the updates work:

USE mysql;
SELECT host, user, max_user_connections, max_connections FROM user;

I've also tried deleting and re-creating the user.

What would it take to make these updates affect the current instance? We'd
like to avoid restarts.

regards
/Staffan