I wonder if the new value in the `user` table will take effect if you FLUSH PRIVELEGES. This may be a workaround.
On Tue, Nov 27, 2018, 2:39 PM Staffan <[email protected] wrote: > I've found a simple repro case so I reported > https://jira.mariadb.org/browse/MDEV-17852 > > /Staffan > > On Mon, Nov 26, 2018 at 9:14 PM Staffan <[email protected]> wrote: > >> 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 >> >> _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
