Difference between revisions of "MariaDB/SQL/CREATE"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< MariaDB‎ | SQL
Jump to navigation Jump to search
Line 3: Line 3:
 
==Example==
 
==Example==
 
* <syntaxhighlight inline lang=SQL>CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';</syntaxhighlight>
 
* <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.

Revision as of 18:45, 16 February 2025

Related

  • DROP deletes existing users

Example

  • CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';
    • Note: Sometimes it only works if you quote the entire user-spec, as in 'roundcube@localhost'. I'm trying to figure out what the rule is.
Retrieved from "https://htyp.org/mw/index.php?title=MariaDB/SQL/CREATE&oldid=29079"