Creating New MariaDB Databases: Difference between revisions
Jump to navigation
Jump to search
Tag: wikieditor |
Tag: wikieditor |
||
| Line 20: | Line 20: | ||
== Grant user access to database == | == Grant user access to database == | ||
To grant access to all objects in the database to a user: | |||
<syntaxhighlight lang="mysql"> | <syntaxhighlight lang="mysql"> | ||
GRANT | GRANT ALL PRIVILEDGES ON example_database.* TO 'user_name'@'192.123.123.*' IDENTIFIED BY 'my_password'; | ||
TO 'user_name'@'192.123.123. | |||
</syntaxhighlight> | </syntaxhighlight> | ||
== Reference == | == Reference == | ||
<references /> | <references /> | ||
Revision as of 22:30, 4 March 2024
Create user
MariaDB User management knowledge base. [1]
CREATE OR REPLACE USER 'user_name'@'host' IDENTIFIED BY 'password';
Host can be something like localhost or '192.123.123.0/24'. [2]
IP addresses need to be surrounded by quotes. Put the user name in quotes and the host in quotes, but not the @ symbol.
Password is supplied as-is. Unencrypted and not passed through the PASSWORD() function.
Create database
CREATE DATABASE IF NOT EXISTS example_database;
Grant user access to database
To grant access to all objects in the database to a user:
GRANT ALL PRIVILEDGES ON example_database.* TO 'user_name'@'192.123.123.*' IDENTIFIED BY 'my_password';