MariaDB/SQL/ALTER

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