Re: [Maria-discuss] Question on ALTER USER
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 > > 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 MariaDBI would appreciate if somebody with a clear eye can > >> > quickly answer my questionappreciate 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 > >> > > >> -- > >> Chris Calender, M.S., Technical Support Manager > >> MariaDB Corporation > >> Regards, Sergei VP of MariaDB Server Engineering and secur...@mariadb.org ___ 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
Re: [Maria-discuss] Question on ALTER USER
> 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 > 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 MariaDBI would appreciate if somebody with a clear eye can >> > quickly answer my questionappreciate 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 >> > ___ 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
Re: [Maria-discuss] Question on ALTER USER
ALTER USER was introduced in MariaDB 10.2. You are using 10.1. Cheers,Federico On Tuesday, 30 July 2019, 21:50:52 BST, Sean T Shen wrote: Hi, experts I don't really know where to ask this question in. And my question is with MariaDBI would appreciate if somebody with a clear eye can quickly answer my questionappreciate 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 ___ 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
[Maria-discuss] Question on ALTER USER
Hi, experts I don't really know where to ask this question in. And my question is with MariaDBI would appreciate if somebody with a clear eye can quickly answer my questionappreciate 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