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
m
 
Line 1: Line 1:
{{fmt/title|"ALTER" SQL statement}}
+
{{fmt/title|"ALTER" SQL command}}
 
==Related==
 
==Related==
 
* This modifies users created by {{l/same|CREATE}}.
 
* This modifies users created by {{l/same|CREATE}}.

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!';