MariaDB/SQL/ALTER

"ALTER" SQL statement

{{#set: page title="ALTER" SQL statement }}

Related

• This modifies users created by CREATE.

Reference

• MariaDB Knowledge Base

Syntax

Note: The following is incomplete.

ALTER USER [IF EXISTS]

<user spec> [, repeat...]

[REQUIRE {NONE | <TLS option> [[AND] repeat...]}]

[WITH <resource option> [repeat...]]

[ <lock option> ] [ <password option> ]

argument name	value(s)
<user spec>	<username> [ <auth option> ]
<auth option> (authentication option)	one of – IDENTIFIED BY '<password>' IDENTIFIED BY PASSWORD '<password hash>' IDENTIFIED {VIA|WITH} <authentication rule> [OR repeat...]
<resource option>	one of – MAX_QUERIES_PER_HOUR <count> MAX_UPDATES_PER_HOUR <count> MAX_CONNECTIONS_PER_HOUR <count> MAX_USER_CONNECTIONS <count> MAX_STATEMENT_TIME <time>
<lock option>	one of – ACCOUNT LOCK ACCOUNT UNLOCK
<password option>	one of – PASSWORD EXPIRE PASSWORD EXPIRE DEFAULT PASSWORD EXPIRE NEVER PASSWORD EXPIRE INTERVAL N DAY
<authentication rule>	one of – <authentication plugin> <authentication plugin> {USING|AS} '<authentication string>' <authentication plugin> {USING|AS} PASSWORD('<password>')
<authentication plugin>	one of – <authentication plugin> {USING|AS} '<authentication string>' <authentication plugin> {USING|AS} PASSWORD('<password>')

Example

• ALTER USER 'rc-bot'@localhost IDENTIFIED BY 'YourPassword!';
  • Note that the syntax