Difference between revisions of "MariaDB/SQL/ALTER"

Revision as of 03:18, 17 February 2025

"ALTER" SQL statement

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>`')`

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

@@ Line 2: / Line 2: @@
 ==Related==
 * This modifies users created by {{l/same|CREATE}}.
+==Reference==
+* [https://mariadb.com/kb/en/alter-user/ MariaDB Knowledge Base]
 ==Syntax==
+'''Note''': The following is incomplete.
 <code>ALTER USER</code> [<code>IF EXISTS</code>]
 : {{fmt/arg|user spec}} [, ''repeat...'']
@@ Line 12: / Line 16: @@
 ! argument name || value(s)
 |-
-| valign=top | '''{{fmt/arg|user spec}}''' || {{fmt/arg|username}} {{fmt/arg/opt|authentication option}}
+| valign=top | '''{{fmt/arg|user spec}}''' || {{fmt/arg|username}} {{fmt/arg/opt|auth option}}
 |-
-| valign=top | '''{{fmt/arg|TLS option}}''' || ''one of &ndash;''
+| valign=top | '''{{fmt/arg|auth option}}'''<br>(authentication option) || ''one of &ndash;''
 * <code>IDENTIFIED BY '</code>{{fmt/arg|password}}<code>'</code>
 * <code>IDENTIFIED BY PASSWORD '</code>{{fmt/arg|password hash}}<code>'</code>
@@ Line 45: / Line 49: @@
 * {{fmt/arg|authentication plugin}} {<code>USING</code>|<code>AS</code>} <code>PASSWORD('</code>{{fmt/arg|password}}<code>')</code>
 |}
+==Example==
+* <syntaxhighlight inline lang=SQL>ALTER USER 'rc-bot'@localhost IDENTIFIED BY 'YourPassword!';</syntaxhighlight>
+**  Note that the syntax