MariaDB/SQL/CREATE/USER: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
No edit summary |
No edit summary |
||
| 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>; | |||
Latest revision as of 02:02, 26 April 2026
Reference
Related
[[../../DROP/USER|DROP USER]]deletes specified existing users
Example
- Template:Fmt/syntax/inline
- 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?
- Note:
- Template:Fmt/syntax/inlineTemplate:Arg
';
