MariaDB/SQL/ALTER: Difference between revisions

Revision as of 03:08, 17 February 2025

ALTER USER [IF EXISTS]

[REQUIRE {NONE | Template:Fmt/arg [[AND] repeat...]}]

[WITH Template:Fmt/arg [repeat...]]

argument name	value(s)
Template:Fmt/arg	Template:Fmt/arg Template:Fmt/arg/opt
Template:Fmt/arg	one of – `IDENTIFIED BY '`Template:Fmt/arg`'` `IDENTIFIED BY PASSWORD '`Template:Fmt/arg`'` `IDENTIFIED` {`VIA`\|`WITH`} Template:Fmt/arg [`OR` repeat...]
Template:Fmt/arg	one of – `MAX_QUERIES_PER_HOUR` Template:Fmt/arg `MAX_UPDATES_PER_HOUR` Template:Fmt/arg `MAX_CONNECTIONS_PER_HOUR` Template:Fmt/arg `MAX_USER_CONNECTIONS` Template:Fmt/arg `MAX_STATEMENT_TIME` Template:Fmt/arg
Template:Fmt/arg	one of – `ACCOUNT LOCK` `ACCOUNT UNLOCK`
Template:Fmt/arg	one of – `PASSWORD EXPIRE` `PASSWORD EXPIRE DEFAULT` `PASSWORD EXPIRE NEVER` `PASSWORD EXPIRE INTERVAL N DAY`
Template:Fmt/arg	one of – Template:Fmt/arg Template:Fmt/arg {`USING`\|`AS`} `'`Template:Fmt/arg`'` Template:Fmt/arg {`USING`\|`AS`} `PASSWORD('`Template:Fmt/arg`')`
Template:Fmt/arg	one of – Template:Fmt/arg {`USING`\|`AS`} 'Template:Fmt/arg' Template:Fmt/arg {`USING`\|`AS`} `PASSWORD('`Template:Fmt/arg`')`

@@ 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...'']
 |-