MariaDB/SQL/CREATE: 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 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

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.