MariaDB/SQL/CREATE/USER

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< MariaDB‎ | SQL‎ | CREATE
Jump to navigation Jump to search
"CREATE USER" SQL command

Reference

Related

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?