Difference between revisions of "MariaDB/SQL/CREATE/USER"
Jump to navigation
Jump to search
(Created page with "{{fmt/title|"CREATE USER" SQL command}} ==Reference== * [https://mariadb.com/kb/en/create-user/ MariaDB Knowledge Base] ==Related== * <code>DROP USER</code> d...") |
|||
| 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? | ||
Latest revision as of 22:01, 18 February 2025
|
"CREATE USER" SQL command
|
Reference
Related
DROP USERdeletes specified existing users
Example
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?
- Note: