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

On 7/30/2019 4:49 PM, Sean T Shen wrote:
> 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 line 1
>
> What did I do wrong?
>
> Thanks
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>


--
Chris Calender, M.S., Technical Support Manager
MariaDB Corporation