MariaDB/SQL/ALTER

Related

• This modifies users created by Template:L/same.

Reference

• MariaDB Knowledge Base

Syntax

Note: The table below is incomplete.

ALTER USER [IF EXISTS]

Template:Fmt/arg [, repeat...]

[REQUIRE {NONE | Template:Fmt/arg [[AND] repeat...]}]

[WITH Template:Fmt/arg [repeat...]]

Template:Fmt/arg/opt Template:Fmt/arg/opt

argument name	value(s)
Template:Fmt/arg	Template:Fmt/arg Template:Fmt/arg/opt
Template:Fmt/arg (authentication option)	one of – IDENTIFIED BY 'Template:Fmt/arg' IDENTIFIED BY PASSWORD 'Template:Fmt/arg' IDENTIFIED {VIA|WITH} Template:Fmt/arg [OR repeat...]
Template:Fmt/arg	one of – MAX_QUERIES_PER_HOUR Template:Fmt/arg MAX_UPDATES_PER_HOUR Template:Fmt/arg MAX_CONNECTIONS_PER_HOUR Template:Fmt/arg MAX_USER_CONNECTIONS Template:Fmt/arg MAX_STATEMENT_TIME Template:Fmt/arg
Template:Fmt/arg	one of – ACCOUNT LOCK ACCOUNT UNLOCK
Template:Fmt/arg	one of – PASSWORD EXPIRE PASSWORD EXPIRE DEFAULT PASSWORD EXPIRE NEVER PASSWORD EXPIRE INTERVAL N DAY
Template:Fmt/arg	one of – Template:Fmt/arg Template:Fmt/arg {USING|AS} 'Template:Fmt/arg' Template:Fmt/arg {USING|AS} PASSWORD('Template:Fmt/arg')
Template:Fmt/arg	one of – Template:Fmt/arg {USING|AS} 'Template:Fmt/arg' Template:Fmt/arg {USING|AS} PASSWORD('Template:Fmt/arg')

Example

• ALTER USER 'rc-bot'@localhost IDENTIFIED BY 'YourPassword!';