MariaDB server<\/a>, invoke this command below:<\/p>\n\n\n\n# apt install mariadb-server<\/pre>\n\n\n\nOn an Ubuntu system, the MariaDB server will be running automatically upon installation. Therefore, we can now continue by creating a fresh database and database user for our LibreNMS website. Let’s log in to MySQL shell as root users and create a database for our LibreNMS website.<\/p>\n\n\n\n
# mysql<\/pre>\n\n\n\nOnce logged in to MySQL shell, we can run the following commands.<\/p>\n\n\n\n
mysql> CREATE DATABASE librenms;
mysql> GRANT ALL on librenms.* to librenms@localhost identified by 'm0d1fyth15';
mysql> FLUSH PRIVILEGES;
mysql> \\q<\/pre>\n\n\n\nMake sure to create a more complicated database password and substitute m0d1fyth15 in the command above with a stronger one.<\/p>\n\n\n\n
After this, we also need to modify our SQL_MODE<\/p>\n\n\n\n
# nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/pre>\n\n\n\nAdd this line under section [mysqld]<\/p>\n\n\n\n
sql_mode = \"\"
innodb_file_per_table=1
lower_case_table_names=0<\/pre>\n\n\n\nThen, restart the MariaDB server<\/p>\n\n\n\n
# systemctl restart mariadb<\/pre>\n\n\n\n