Creating New MariaDB Databases

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 IF NOT EXISTS example_database;

GRANT ALTER TO example_database
TO 'user_name'@'192.123.123.0/24';