Creating New MariaDB Databases

Create user

MariaDB User management knowledge base.

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

Host can be something like localhost or '192.123.123.0/24'.

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';