Difference between revisions of "MariaDB/SQL/CREATE"

Revision as of 19:11, 16 February 2025

CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';
- Note: 'roundcube@localhost' is not the same user as 'roundcube'@localhost. 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?

@@ Line 3: / Line 3: @@
 ==Example==
 * <syntaxhighlight inline lang=SQL>CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';</syntaxhighlight>
-** '''Note''': Sometimes it only works if you quote the entire user-spec, as in <code>'roundcube@localhost'</code>. I'm trying to figure out what the rule is.
+** '''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?