MariaDB databases configuration¶

For Muscat¶

As root, enter db database interactive monitor, and use this sequence for each user (ddd, traces, ifmuc), including quotes (') as in this document:

# mariadb -u root -p
[your-maria-db-admin-password]
MariaDB [(none)]> CREATE DATABASE traces_development CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0.000 sec)

MariaDB [(none)]> CREATE DATABASE traces CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0.000 sec)

MariaDB [(none)]> CREATE USER 'traces'@'localhost';                                                                                                                                                   
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> ALTER USER 'traces'@'localhost' IDENTIFIED BY '[your-traces@localhost-password]';
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> GRANT ALL ON traces_development.* TO 'traces'@'localhost';
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> GRANT ALL ON traces.* TO 'traces'@'localhost';
Query OK, 0 rows affected (0.002 sec)

MariaDB [(none)]> ^DBye