Difference between revisions of "MariaDB/SQL/ALTER"

Revision as of 03:08, 17 February 2025

"ALTER" SQL statement

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> [ <authentication option> ]
<TLS 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>`')`

@@ Line 15: / Line 15: @@
 |-
 | valign=top | '''{{fmt/arg|TLS option}}''' || ''one of &ndash;''
-* <code>IDENTIFIED BY</code> '{{fmt/arg|password}}'
+* <code>IDENTIFIED BY '</code>{{fmt/arg|password}}<code>'</code>
-* <code>IDENTIFIED BY PASSWORD</code> '{{fmt/arg|password hash}}'
+* <code>IDENTIFIED BY PASSWORD '</code>{{fmt/arg|password hash}}<code>'</code>
 * <code>IDENTIFIED</code> {<code>VIA</code>|<code>WITH</code>} {{fmt/arg|authentication rule}} [<code>OR</code> ''repeat...'']
 |-