maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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@xxxxxxxxxxx>
> > 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
> >> >
> >> --
> >> Chris Calender, M.S., Technical Support Manager
> >> MariaDB Corporation
> >>

Regards,
Sergei
VP of MariaDB Server Engineering
and security@xxxxxxxxxxx