> 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 <[email protected]> > 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 : [email protected] >> > Unsubscribe : https://launchpad.net/~maria-discuss >> > More help : https://help.launchpad.net/ListHelp >> > >> >> >> -- >> Chris Calender, M.S., Technical Support Manager >> MariaDB Corporation >> >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
