Hi, Sean! Use GRANT instead of ALTER USER before 10.2 GRANT USAGE ON *.* TO 'user1'@'localhost' WITH MAX_USER_CONNECTIONS 0; On Jul 30, Sean T Shen wrote:
Thanks. In this case, the way to control connections is through global variables? Such as this: SET GLOBAL max_connections = 500; there is no individual control on how many connections each user can have, with my version?
On Tue, Jul 30, 2019 at 5:10 PM Chris Calender <chris.calender@mariadb.com> wrote:
Hello Sean,
Both resource limit options and ALTER USER are not available until MariaDB 10.2.0. You would need to upgrade to a newer version to be able to set the resource limit option MAX_USER_CONNECTIONS.
The latest 10.2 (10.2.25), 10.3 (10.3.16), and 10.4 (10.4.6) are available here:
https://mariadb.com/downloads/#mariadb_platform-mariadb_server
Hope this helps.
Best wishes, Chris
Hi, experts
I don't really know where to ask this question in. And my question is with MariaDB....I would appreciate if somebody with a clear eye can quickly answer my question....appreciate it very much.
My MariaDb is of this version: '10.1.38-MariaDB-0+deb9u1' My OS where mariadb is running is this: 'Linux d-bia-mysql-use1c-1 4.9.0-9-amd64 #1 SMP Debian 4.9.168-1+deb9u4 (2019-07-19) x86_64 GNU/Linux'
I just want to do this
ALTER USER 'user1'@'localhost' WITH MAX_USER_CONNECTIONS 0;
And I am getting syntax error:
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER 'user1'@'localhost' WITH MAX_USER_CONNECTIONS 0' at
On 7/30/2019 4:49 PM, Sean T Shen wrote: line 1
What did I do wrong?
Thanks
-- Chris Calender, M.S., Technical Support Manager MariaDB Corporation
Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org