MariaDB/SQL/CREATE

Related

• DROP deletes 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?