ALTER USER 'XYZ'@'HOSTNAME' WITH MAX_USER_CONNECTIONS 0
Hi, experts
I dont really know where to ask this question in. And my question is with MariaDB....but 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
Answer Answered by Faustin Lammler in this comment.
Hi, quoting Federico Razzoli on [email protected]:
ALTER USER was introduced in MariaDB 10.2. You are using 10.1.
See https://mariadb.com/kb/en/library/alter-user/
Regards,
Faustin