Change users connection limits

WebCF's profile image WebCF posted 3 years ago in General Permalink

Heidi 11.3.0.6295.

MySQL: 5.7.34

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.

WebCF's profile image WebCF posted 3 years ago Permalink

Another "error"? => The mysql.user value for max_user_connections is 50 but the input field value is still 0:

select max_user_connections FROM mysql.user WHERE User = 'user' : 50 But the window: Simultaneous connections: 0

So maybe we have actually only one problem: The value is not displayed correctly.

The update statement should work but should also be updated in future releases.

Please login to leave a reply, or register at first.