Creating New MariaDB Databases

From Littledamien Wiki
Revision as of 21:48, 4 March 2024 by Video8 (talk | contribs) (Created page with "[https://mariadb.com/kb/en/create-user/ Create a user]. <syntaxhighlight lang="mysql"> CREATE OR REPLACE USER 'user_name'@'host' IDENTIFIED BY 'password'; </syntaxhighlight> `Host` can be something like `'localhost'` or `'192.123.123.%'`. Put quotes around `user_name` and `host`, but not the @ symbol. Password is supplied as-is. Unencrypted and not passed through the `PASSWORD()` function.")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Create a user. 

CREATE OR REPLACE USER 'user_name'@'host' IDENTIFIED BY 'password';

Host can be something like 'localhost' or '192.123.123.%'.

Put quotes around user_name and host, but not the @ symbol.

Password is supplied as-is. Unencrypted and not passed through the PASSWORD() function.

Retrieved from "https://wiki.dbarchowsky.com/index.php?title=Creating_New_MariaDB_Databases&oldid=3599"