Issue: I want to edit the users max connections. But the counter resets to 0 after saving the new values.
Heidi creates this query:
GRANT USAGE ON *.* TO 'nextcloud'@'%' WITH MAX_USER_CONNECTIONS 50;
When I manually execute it:
Using GRANT statement to modify existing user's properties other than priviliges is deprecated and will be removed in future release. Use ALTER USER statement for this operation
The max_connection counter is then still 0.