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;
>
> 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:
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
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
4 matches
Mail list logo