MariaDB/SQL/ALTER - Revision history

Woozle at 00:41, 26 April 2026

2026-04-26T00:41:50Z

← Older revision		Revision as of 00:41, 26 April 2026
Line 1:		Line 1:
	{{fmt/title\|~~"ALTER"~~ SQL command}}		{{fmt/title\|SQL command: <code>ALTER</code>}}
	==Related==		==Related==
	* This modifies ~~users~~ created by {{l/same\|CREATE}}.		* This modifies [[../user/]]s created by {{l/same\|CREATE}}.
	==Reference==		==Reference==
	* [https://mariadb.com/kb/en/alter-user/ MariaDB Knowledge Base]		* [https://mariadb.com/kb/en/alter-user/ MariaDB Knowledge Base]

Woozle at 21:45, 18 February 2025

2025-02-18T21:45:56Z

← Older revision		Revision as of 21:45, 18 February 2025
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}}.

Woozle at 03:19, 17 February 2025

2025-02-17T03:19:12Z

← Older revision		Revision as of 03:19, 17 February 2025
Line 5:		Line 5:
	* [https://mariadb.com/kb/en/alter-user/ MariaDB Knowledge Base]		* [https://mariadb.com/kb/en/alter-user/ MariaDB Knowledge Base]
	==Syntax==		==Syntax==
	'''Note''': The ~~following~~ is incomplete.		'''Note''': The table below is incomplete.

	<code>ALTER USER</code> [<code>IF EXISTS</code>]		<code>ALTER USER</code> [<code>IF EXISTS</code>]
Line 51:		Line 51:
	==Example==		==Example==
	* <syntaxhighlight inline lang=SQL>ALTER USER 'rc-bot'@localhost IDENTIFIED BY 'YourPassword!';</syntaxhighlight>		* <syntaxhighlight inline lang=SQL>ALTER USER 'rc-bot'@localhost IDENTIFIED BY 'YourPassword!';</syntaxhighlight>
	** Note that the syntax

Woozle at 03:18, 17 February 2025

2025-02-17T03:18:19Z

← Older revision		Revision as of 03:18, 17 February 2025
Line 2:		Line 2:
	==Related==		==Related==
	* This modifies users created by {{l/same\|CREATE}}.		* This modifies users created by {{l/same\|CREATE}}.
			==Reference==
			* [https://mariadb.com/kb/en/alter-user/ MariaDB Knowledge Base]
	==Syntax==		==Syntax==
			'''Note''': The following is incomplete.

	<code>ALTER USER</code> [<code>IF EXISTS</code>]		<code>ALTER USER</code> [<code>IF EXISTS</code>]
	: {{fmt/arg\|user spec}} [, ''repeat...'']		: {{fmt/arg\|user spec}} [, ''repeat...'']
Line 12:		Line 16:
	! argument name \|\| value(s)		! argument name \|\| value(s)
	\|-		\|-
	\| valign=top \| '''{{fmt/arg\|user spec}}''' \|\| {{fmt/arg\|username}} {{fmt/arg/opt\|~~authentication~~ option}}		\| valign=top \| '''{{fmt/arg\|user spec}}''' \|\| {{fmt/arg\|username}} {{fmt/arg/opt\|auth option}}
	\|-		\|-
	\| valign=top \| '''{{fmt/arg\|~~TLS~~ option}}''' \|\| ''one of –''		\| valign=top \| '''{{fmt/arg\|auth option}}'''<br>(authentication option) \|\| ''one of –''
	* <code>IDENTIFIED BY '</code>{{fmt/arg\|password}}<code>'</code>		* <code>IDENTIFIED BY '</code>{{fmt/arg\|password}}<code>'</code>
	* <code>IDENTIFIED BY PASSWORD '</code>{{fmt/arg\|password hash}}<code>'</code>		* <code>IDENTIFIED BY PASSWORD '</code>{{fmt/arg\|password hash}}<code>'</code>
Line 45:		Line 49:
	* {{fmt/arg\|authentication plugin}} {<code>USING</code>\|<code>AS</code>} <code>PASSWORD('</code>{{fmt/arg\|password}}<code>')</code>		* {{fmt/arg\|authentication plugin}} {<code>USING</code>\|<code>AS</code>} <code>PASSWORD('</code>{{fmt/arg\|password}}<code>')</code>
	\|}		\|}
			==Example==
			* <syntaxhighlight inline lang=SQL>ALTER USER 'rc-bot'@localhost IDENTIFIED BY 'YourPassword!';</syntaxhighlight>
			** Note that the syntax

Woozle at 03:08, 17 February 2025

2025-02-17T03:08:11Z

← Older revision		Revision as of 03:08, 17 February 2025
Line 15:		Line 15:
	\|-		\|-
	\| valign=top \| '''{{fmt/arg\|TLS option}}''' \|\| ''one of –''		\| valign=top \| '''{{fmt/arg\|TLS option}}''' \|\| ''one of –''
	* <code>IDENTIFIED BY</code> '{{fmt/arg\|password}}'		* <code>IDENTIFIED BY '</code>{{fmt/arg\|password}}<code>'</code>
	* <code>IDENTIFIED BY PASSWORD</code> '{{fmt/arg\|password hash}}'		* <code>IDENTIFIED BY PASSWORD '</code>{{fmt/arg\|password hash}}<code>'</code>
	* <code>IDENTIFIED</code> {<code>VIA</code>\|<code>WITH</code>} {{fmt/arg\|authentication rule}} [<code>OR</code> ''repeat...'']		* <code>IDENTIFIED</code> {<code>VIA</code>\|<code>WITH</code>} {{fmt/arg\|authentication rule}} [<code>OR</code> ''repeat...'']
	\|-		\|-

Woozle at 03:03, 17 February 2025

2025-02-17T03:03:11Z

← Older revision		Revision as of 03:03, 17 February 2025
Line 1:		Line 1:
			{{fmt/title\|"ALTER" SQL statement}}
	==Related==		==Related==
	* This modifies users created by {{l/same\|CREATE}}.		* This modifies users created by {{l/same\|CREATE}}.
	==Syntax==		==Syntax==
	<code>ALTER USER</code> [<code>IF EXISTS</code>] {{fmt/arg\|user spec}} [, ''repeat...''] [<code>REQUIRE</code> {<code>NONE</code> \| {{fmt/arg\|TLS option}} [[<code>AND</code>] ''repeat...'']} [<code>WITH</code> {{fmt/arg\|resource option}} [''repeat...'']] {{fmt/arg/opt\|lock option}} {{fmt/arg/opt\|password option}}		<code>ALTER USER</code> [<code>IF EXISTS</code>]
	* '''{{fmt/arg\|user spec}}''': {{fmt/arg\|username}} {{fmt/arg/opt\|authentication option}}		: {{fmt/arg\|user spec}} [, ''repeat...'']
	* '''{{fmt/arg\|TLS option}}''': ''one of –''		: [<code>REQUIRE</code> {<code>NONE</code> \| {{fmt/arg\|TLS option}} [[<code>AND</code>] ''repeat...'']}]
	** <code>IDENTIFIED BY</code> '{{fmt/arg\|password}}'		: [<code>WITH</code> {{fmt/arg\|resource option}} [''repeat...'']]
	** <code>IDENTIFIED BY PASSWORD</code> '{{fmt/arg\|password hash}}'		: {{fmt/arg/opt\|lock option}} {{fmt/arg/opt\|password option}}
	** <code>IDENTIFIED</code> {<code>VIA</code>\|<code>WITH</code>} {{fmt/arg\|authentication rule}} [<code>OR</code> ''repeat...'']
	* '''{{fmt/arg\|resource option}}''': ''one of –''		{\| class="wikitable sortable"
	** <code>MAX_QUERIES_PER_HOUR</code> {{fmt/arg\|count}}		! argument name \|\| value(s)
	** <code>MAX_UPDATES_PER_HOUR</code> {{fmt/arg\|count}}		\|-
	** <code>MAX_CONNECTIONS_PER_HOUR</code> {{fmt/arg\|count}}		\| valign=top \| '''{{fmt/arg\|user spec}}''' \|\| {{fmt/arg\|username}} {{fmt/arg/opt\|authentication option}}
	** <code>MAX_USER_CONNECTIONS</code> {{fmt/arg\|count}}		\|-
	** <code>MAX_STATEMENT_TIME</code> {{fmt/arg\|time}}		\| valign=top \| '''{{fmt/arg\|TLS option}}''' \|\| ''one of –''
	* '''{{fmt/arg\|lock option}}''': ''one of –''		* <code>IDENTIFIED BY</code> '{{fmt/arg\|password}}'
	** <code>ACCOUNT LOCK</code>		* <code>IDENTIFIED BY PASSWORD</code> '{{fmt/arg\|password hash}}'
	** <code>ACCOUNT UNLOCK</code>		* <code>IDENTIFIED</code> {<code>VIA</code>\|<code>WITH</code>} {{fmt/arg\|authentication rule}} [<code>OR</code> ''repeat...'']
	* '''{{fmt/arg\|password option}}''': ''one of –''		\|-
	** <code>PASSWORD EXPIRE</code>		\| valign=top \| '''{{fmt/arg\|resource option}}''' \|\| ''one of –''
	** <code>PASSWORD EXPIRE DEFAULT</code>		* <code>MAX_QUERIES_PER_HOUR</code> {{fmt/arg\|count}}
	** <code>PASSWORD EXPIRE NEVER</code>		* <code>MAX_UPDATES_PER_HOUR</code> {{fmt/arg\|count}}
	** <code>PASSWORD EXPIRE INTERVAL N DAY</code>		* <code>MAX_CONNECTIONS_PER_HOUR</code> {{fmt/arg\|count}}
	* '''{{fmt/arg\|authentication rule}}''': ''one of –''		* <code>MAX_USER_CONNECTIONS</code> {{fmt/arg\|count}}
	** {{fmt/arg\|authentication plugin}}		* <code>MAX_STATEMENT_TIME</code> {{fmt/arg\|time}}
	** {{fmt/arg\|authentication plugin}} {<code>USING</code>\|<code>AS</code>} <code>'</code>{{fmt/arg\|authentication string}}<code>'</code>		\|-
	** {{fmt/arg\|authentication plugin}} {<code>USING</code>\|<code>AS</code>} <code>PASSWORD('</code>{{fmt/arg\|password}}<code>')</code>		\| valign=top \| '''{{fmt/arg\|lock option}}''' \|\| ''one of –''
	* '''{{fmt/arg\|authentication plugin}}''': ''one of –''		* <code>ACCOUNT LOCK</code>
	** {{fmt/arg\|authentication plugin}} {<code>USING</code>\|<code>AS</code>} '{{fmt/arg\|authentication string}}'		* <code>ACCOUNT UNLOCK</code>
	** {{fmt/arg\|authentication plugin}} {<code>USING</code>\|<code>AS</code>} <code>PASSWORD('</code>{{fmt/arg\|password}}<code>')</code>		\|-
			\| valign=top \| '''{{fmt/arg\|password option}}''' \|\| ''one of –''
			* <code>PASSWORD EXPIRE</code>
			* <code>PASSWORD EXPIRE DEFAULT</code>
			* <code>PASSWORD EXPIRE NEVER</code>
			* <code>PASSWORD EXPIRE INTERVAL N DAY</code>
			\|-
			\| valign=top \| '''{{fmt/arg\|authentication rule}}''' \|\| ''one of –''
			* {{fmt/arg\|authentication plugin}}
			* {{fmt/arg\|authentication plugin}} {<code>USING</code>\|<code>AS</code>} <code>'</code>{{fmt/arg\|authentication string}}<code>'</code>
			* {{fmt/arg\|authentication plugin}} {<code>USING</code>\|<code>AS</code>} <code>PASSWORD('</code>{{fmt/arg\|password}}<code>')</code>
			\|-
			\| valign=top \| '''{{fmt/arg\|authentication plugin}}''' \|\| ''one of –''
			* {{fmt/arg\|authentication plugin}} {<code>USING</code>\|<code>AS</code>} '{{fmt/arg\|authentication string}}'
			* {{fmt/arg\|authentication plugin}} {<code>USING</code>\|<code>AS</code>} <code>PASSWORD('</code>{{fmt/arg\|password}}<code>')</code>
			\|}

Woozle: Created page with "==Related== * This modifies users created by {{l/same|CREATE}}. ==Syntax== `ALTER USER` [`IF EXISTS`] {{fmt/arg|user spec}} [, ''repeat...''] [`REQU..."`


2025-02-17T02:37:55Z
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..."
New page
==Related==

* This modifies users created by {{l/same|CREATE}}.

==Syntax==

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

* '''{{fmt/arg|user spec}}''': {{fmt/arg|username}} {{fmt/arg/opt|authentication option}}

* '''{{fmt/arg|TLS option}}''': ''one of &ndash;''

** <code>IDENTIFIED BY</code> '{{fmt/arg|password}}'

** <code>IDENTIFIED BY PASSWORD</code> '{{fmt/arg|password hash}}'

** <code>IDENTIFIED</code> {<code>VIA</code>|<code>WITH</code>} {{fmt/arg|authentication rule}} [<code>OR</code> ''repeat...'']

* '''{{fmt/arg|resource option}}''': ''one of &ndash;''

** <code>MAX_QUERIES_PER_HOUR</code> {{fmt/arg|count}}

** <code>MAX_UPDATES_PER_HOUR</code> {{fmt/arg|count}}

** <code>MAX_CONNECTIONS_PER_HOUR</code> {{fmt/arg|count}}

** <code>MAX_USER_CONNECTIONS</code> {{fmt/arg|count}}

** <code>MAX_STATEMENT_TIME</code> {{fmt/arg|time}}

* '''{{fmt/arg|lock option}}''': ''one of &ndash;''

** <code>ACCOUNT LOCK</code>

** <code>ACCOUNT UNLOCK</code>

* '''{{fmt/arg|password option}}''': ''one of &ndash;''

** <code>PASSWORD EXPIRE</code>

** <code>PASSWORD EXPIRE DEFAULT</code>

** <code>PASSWORD EXPIRE NEVER</code>

** <code>PASSWORD EXPIRE INTERVAL N DAY</code>

* '''{{fmt/arg|authentication rule}}''': ''one of &ndash;''

** {{fmt/arg|authentication plugin}}

** {{fmt/arg|authentication plugin}} {<code>USING</code>|<code>AS</code>} <code>'</code>{{fmt/arg|authentication string}}<code>'</code>

** {{fmt/arg|authentication plugin}} {<code>USING</code>|<code>AS</code>} <code>PASSWORD('</code>{{fmt/arg|password}}<code>')</code>

* '''{{fmt/arg|authentication plugin}}''': ''one of &ndash;''

** {{fmt/arg|authentication plugin}} {<code>USING</code>|<code>AS</code>} '{{fmt/arg|authentication string}}'

** {{fmt/arg|authentication plugin}} {<code>USING</code>|<code>AS</code>} <code>PASSWORD('</code>{{fmt/arg|password}}<code>')</code>

MariaDB/SQL/ALTER - Revision history

Woozle at 00:41, 26 April 2026

Woozle at 21:45, 18 February 2025

Woozle at 03:19, 17 February 2025

Woozle at 03:18, 17 February 2025

Woozle at 03:08, 17 February 2025

Woozle at 03:03, 17 February 2025

Woozle: Created page with "==Related== * This modifies users created by {{l/same|CREATE}}. ==Syntax== ALTER USER [IF EXISTS] {{fmt/arg|user spec}} [, ''repeat...''] [REQU..."

Woozle: Created page with "==Related== * This modifies users created by {{l/same|CREATE}}. ==Syntax== `ALTER USER` [`IF EXISTS`] {{fmt/arg|user spec}} [, ''repeat...''] [`REQU..."`