MariaDB/SQL/CREATE/USER - Revision history

Woozle at 02:02, 26 April 2026

2026-04-26T02:02:24Z

← Older revision		Revision as of 02:02, 26 April 2026
Line 8:		Line 8:
	** '''Note''': <code>'roundcube@localhost'</code> is not the same user as <code>'roundcube'@localhost</code>. The latter creates user 'roundcube' with '@localhost' stored in another field, from what I can tell.		** '''Note''': <code>'roundcube@localhost'</code> is not the same user as <code>'roundcube'@localhost</code>. The latter creates user 'roundcube' with '@localhost' stored in another field, from what I can tell.
	** '''Note''': 'password' and "password" are not necessarily identical. At least once, I got an error with 'password' but "password" was fine. The password in question ended with a '^' character, so maybe that was escaping the end-quote-mark or something?		** '''Note''': 'password' and "password" are not necessarily identical. At least once, I got an error with 'password' but "password" was fine. The password in question ended with a '^' character, so maybe that was escaping the end-quote-mark or something?
			* {{fmt/syntax/inline\|SQL\|CREATE USER 'wooz-dev-mw'@'localhost' IDENTIFIED BY '}}{{arg\|password}}<code>'</code>;

Woozle at 22:01, 18 February 2025

2025-02-18T22:01:12Z

← Older revision		Revision as of 22:01, 18 February 2025
Line 3:		Line 3:
	* [https://mariadb.com/kb/en/create-user/ MariaDB Knowledge Base]		* [https://mariadb.com/kb/en/create-user/ MariaDB Knowledge Base]
	==Related==		==Related==
	* <code>[[../DROP/USER\|DROP USER]]</code> deletes existing users		* <code>[[../../DROP/USER\|DROP USER]]</code> deletes specified existing users
	==Example==		==Example==
	* {{fmt/syntax/inline\|SQL\|CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';}}		* {{fmt/syntax/inline\|SQL\|CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';}}
	** '''Note''': <code>'roundcube@localhost'</code> is not the same user as <code>'roundcube'@localhost</code>. The latter creates user 'roundcube' with '@localhost' stored in another field, from what I can tell.		** '''Note''': <code>'roundcube@localhost'</code> is not the same user as <code>'roundcube'@localhost</code>. The latter creates user 'roundcube' with '@localhost' stored in another field, from what I can tell.
	** '''Note''': 'password' and "password" are not necessarily identical. At least once, I got an error with 'password' but "password" was fine. The password in question ended with a '^' character, so maybe that was escaping the end-quote-mark or something?		** '''Note''': 'password' and "password" are not necessarily identical. At least once, I got an error with 'password' but "password" was fine. The password in question ended with a '^' character, so maybe that was escaping the end-quote-mark or something?

Woozle: Created page with "{{fmt/title|"CREATE USER" SQL command}} ==Reference== * [https://mariadb.com/kb/en/create-user/ MariaDB Knowledge Base] ==Related== * `DROP USER` d..."

2025-02-18T21:59:54Z

Created page with "{{fmt/title|"CREATE USER" SQL command}} ==Reference== * [https://mariadb.com/kb/en/create-user/ MariaDB Knowledge Base] ==Related== * <code>[[../DROP/USER|DROP USER]]</code> d..."

New page

{{fmt/title|"CREATE USER" SQL command}}
==Reference==
* [https://mariadb.com/kb/en/create-user/ MariaDB Knowledge Base]
==Related==
* <code>[[../DROP/USER|DROP USER]]</code> deletes existing users
==Example==
* {{fmt/syntax/inline|SQL|CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';}}
** '''Note''': <code>'roundcube@localhost'</code> is not the same user as <code>'roundcube'@localhost</code>. The latter creates user 'roundcube' with '@localhost' stored in another field, from what I can tell.
** '''Note''': 'password' and "password" are not necessarily identical. At least once, I got an error with 'password' but "password" was fine. The password in question ended with a '^' character, so maybe that was escaping the end-quote-mark or something?

MariaDB/SQL/CREATE/USER - Revision history

Woozle at 02:02, 26 April 2026

Woozle at 22:01, 18 February 2025

Woozle: Created page with "{{fmt/title|"CREATE USER" SQL command}} ==Reference== * [https://mariadb.com/kb/en/create-user/ MariaDB Knowledge Base] ==Related== * DROP USER d..."

Woozle: Created page with "{{fmt/title|"CREATE USER" SQL command}} ==Reference== * [https://mariadb.com/kb/en/create-user/ MariaDB Knowledge Base] ==Related== * `DROP USER` d..."