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.%'.

IP addresses need to be surrounded by quotes. Put the user name in quotes and the host in quotes, but not the @ symbol.

Ranges in the IP can be specified with the % wildcard or subnet masks, e.g. 192.123.123.0/255.255.255.0.

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

Flushing privledges

Don't forget to flush the privledes after making changes:

FLUSH PRIVILEGES;