← Back to team overview

maria-discuss team mailing list archive

Re: 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 <seantshen@xxxxxxxxx> 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    : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help  : https://help.launchpad.net/ListHelp
  

References