MariaDB/SQL/ALTER
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>')
- <authentication plugin> {