MariaDB/SQL/ALTER: Difference between revisions

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Woozle (talk | contribs)
Bureaucrats, Interface administrators, interwiki, Administrators, trusted
20,099 edits
VisualWikitext
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..."
 
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{fmt/title|SQL command: <code>ALTER</code>}}
==Related==
==Related==
* This modifies users created by {{l/same|CREATE}}.
* This modifies [[../user/]]s 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 00:41, 26 April 2026

SQL command: ALTER

{{#set: page title=SQL command: ALTER }}

  • This modifies [[../user/]]s created by [[../CREATE|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=29393"