Difference between revisions of "MariaDB/SQL/ALTER"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< MariaDB‎ | SQL
Jump to navigation Jump to search
(Created page with "==Related== * This modifies users created by {{l/same|CREATE}}. ==Syntax== <code>ALTER USER</code> [<code>IF EXISTS</code>] {{fmt/arg|user spec}} [, ''repeat...''] [<code>REQU...")
 
m
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
{{fmt/title|"ALTER" SQL command}}
 
==Related==
 
==Related==
 
* This modifies users created by {{l/same|CREATE}}.
 
* This modifies users created by {{l/same|CREATE}}.
 +
==Reference==
 +
* [https://mariadb.com/kb/en/alter-user/ MariaDB Knowledge Base]
 
==Syntax==
 
==Syntax==
−
<code>ALTER USER</code> [<code>IF EXISTS</code>] {{fmt/arg|user spec}} [, ''repeat...''] [<code>REQUIRE</code> {<code>NONE</code> | {{fmt/arg|TLS option}} [[<code>AND</code>] ''repeat...'']} [<code>WITH</code> {{fmt/arg|resource option}} [''repeat...'']] {{fmt/arg/opt|lock option}} {{fmt/arg/opt|password option}}
+
'''Note''': The table below is incomplete.
−
* '''{{fmt/arg|user spec}}''': {{fmt/arg|username}} {{fmt/arg/opt|authentication option}}
+
 
−
* '''{{fmt/arg|TLS option}}''': ''one of &ndash;''
+
<code>ALTER USER</code> [<code>IF EXISTS</code>]
−
** <code>IDENTIFIED BY</code> '{{fmt/arg|password}}'
+
: {{fmt/arg|user spec}} [, ''repeat...'']
−
** <code>IDENTIFIED BY PASSWORD</code> '{{fmt/arg|password hash}}'
+
: [<code>REQUIRE</code> {<code>NONE</code> | {{fmt/arg|TLS option}} [[<code>AND</code>] ''repeat...'']}]
−
** <code>IDENTIFIED</code> {<code>VIA</code>|<code>WITH</code>} {{fmt/arg|authentication rule}} [<code>OR</code> ''repeat...'']
+
: [<code>WITH</code> {{fmt/arg|resource option}} [''repeat...'']]
−
* '''{{fmt/arg|resource option}}''': ''one of &ndash;''
+
: {{fmt/arg/opt|lock option}} {{fmt/arg/opt|password option}}
−
** <code>MAX_QUERIES_PER_HOUR</code> {{fmt/arg|count}}
+
 
−
** <code>MAX_UPDATES_PER_HOUR</code> {{fmt/arg|count}}
+
{| class="wikitable sortable"
−
** <code>MAX_CONNECTIONS_PER_HOUR</code> {{fmt/arg|count}}
+
! argument name || value(s)
−
** <code>MAX_USER_CONNECTIONS</code> {{fmt/arg|count}}
+
|-
−
** <code>MAX_STATEMENT_TIME</code> {{fmt/arg|time}}
+
| valign=top | '''{{fmt/arg|user spec}}''' || {{fmt/arg|username}} {{fmt/arg/opt|auth option}}
−
* '''{{fmt/arg|lock option}}''': ''one of &ndash;''
+
|-
−
** <code>ACCOUNT LOCK</code>
+
| valign=top | '''{{fmt/arg|auth option}}'''<br>(authentication option) || ''one of &ndash;''
−
** <code>ACCOUNT UNLOCK</code>
+
* <code>IDENTIFIED BY '</code>{{fmt/arg|password}}<code>'</code>
−
* '''{{fmt/arg|password option}}''': ''one of &ndash;''
+
* <code>IDENTIFIED BY PASSWORD '</code>{{fmt/arg|password hash}}<code>'</code>
−
** <code>PASSWORD EXPIRE</code>
+
* <code>IDENTIFIED</code> {<code>VIA</code>|<code>WITH</code>} {{fmt/arg|authentication rule}} [<code>OR</code> ''repeat...'']
−
** <code>PASSWORD EXPIRE DEFAULT</code>
+
|-
−
** <code>PASSWORD EXPIRE NEVER</code>
+
| valign=top | '''{{fmt/arg|resource option}}''' || ''one of &ndash;''
−
** <code>PASSWORD EXPIRE INTERVAL N DAY</code>
+
* <code>MAX_QUERIES_PER_HOUR</code> {{fmt/arg|count}}
−
* '''{{fmt/arg|authentication rule}}''': ''one of &ndash;''
+
* <code>MAX_UPDATES_PER_HOUR</code> {{fmt/arg|count}}
−
** {{fmt/arg|authentication plugin}}
+
* <code>MAX_CONNECTIONS_PER_HOUR</code> {{fmt/arg|count}}
−
** {{fmt/arg|authentication plugin}} {<code>USING</code>|<code>AS</code>} <code>'</code>{{fmt/arg|authentication string}}<code>'</code>
+
* <code>MAX_USER_CONNECTIONS</code> {{fmt/arg|count}}
−
** {{fmt/arg|authentication plugin}} {<code>USING</code>|<code>AS</code>} <code>PASSWORD('</code>{{fmt/arg|password}}<code>')</code>
+
* <code>MAX_STATEMENT_TIME</code> {{fmt/arg|time}}
−
* '''{{fmt/arg|authentication plugin}}''': ''one of &ndash;''
+
|-
−
** {{fmt/arg|authentication plugin}} {<code>USING</code>|<code>AS</code>} '{{fmt/arg|authentication string}}'
+
| valign=top | '''{{fmt/arg|lock option}}''' || ''one of &ndash;''
−
** {{fmt/arg|authentication plugin}} {<code>USING</code>|<code>AS</code>} <code>PASSWORD('</code>{{fmt/arg|password}}<code>')</code>
+
* <code>ACCOUNT LOCK</code>
 +
* <code>ACCOUNT UNLOCK</code>
 +
|-
 +
| valign=top | '''{{fmt/arg|password option}}''' || ''one of &ndash;''
 +
* <code>PASSWORD EXPIRE</code>
 +
* <code>PASSWORD EXPIRE DEFAULT</code>
 +
* <code>PASSWORD EXPIRE NEVER</code>
 +
* <code>PASSWORD EXPIRE INTERVAL N DAY</code>
 +
|-
 +
| valign=top | '''{{fmt/arg|authentication rule}}''' || ''one of &ndash;''
 +
* {{fmt/arg|authentication plugin}}
 +
* {{fmt/arg|authentication plugin}} {<code>USING</code>|<code>AS</code>} <code>'</code>{{fmt/arg|authentication string}}<code>'</code>
 +
* {{fmt/arg|authentication plugin}} {<code>USING</code>|<code>AS</code>} <code>PASSWORD('</code>{{fmt/arg|password}}<code>')</code>
 +
|-
 +
| valign=top | '''{{fmt/arg|authentication plugin}}''' || ''one of &ndash;''
 +
* {{fmt/arg|authentication plugin}} {<code>USING</code>|<code>AS</code>} '{{fmt/arg|authentication string}}'
 +
* {{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>

Latest revision as of 21:45, 18 February 2025

"ALTER" SQL command

Related

  • This modifies users created by CREATE.

Reference

Syntax

Note: The table below 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!';
Retrieved from "https://htyp.org/mw/index.php?title=MariaDB/SQL/ALTER&oldid=29112"