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
Revision as of 02:37, 17 February 2025 by Woozle (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Related

  • This modifies users created by CREATE.

Syntax

ALTER USER [IF EXISTS] <user spec> [, repeat...] [REQUIRE {NONE | <TLS option> [[AND] repeat...]} [WITH <resource option> [repeat...]] [ <lock option> ] [ <password option> ]

  • <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>')