MariaDB

To create a database on an existing MariaDB database server, please use this SQL and adjust it to your needs:

-- ---------
-- USU PORTAL
-- ---------

CREATE DATABASE IF NOT EXISTS usu_portal CHARACTER SET = utf8 COLLATE utf8_unicode_ci;
GRANT ALL ON usu_portal.* TO 'usu_portal'@'%' IDENTIFIED BY 'password';
COMMIT;

FLUSH PRIVILEGES;

For MariaDB please make sure that lower_case_table_names = 1 . If the parameter does not have value 1, the system cannot function.

Please check the default settings for MariaDB in my.cnf/my.ini. They should look like this:

lower_case_table_names = 1
max_connections = 100
collation-server = utf8_unicode_ci
character-set-server = utf8