Configure MySQL

Configure MySQL

Login to MySQL

systemctl start mariadb
mysql -u root

Change the Password

Changing ********************* to some secret password

SET PASSWORD FOR 'root'@'localhost' = PASSWORD("*********************");
flush privileges;
exit;

Create LibreNMS Database and User

mysql -u root -p

Enter the password if asked

CREATE DATABASE librenms CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'librenms'@'localhost' IDENTIFIED BY '**************'; #using the same password as set above
GRANT ALL PRIVILEGES ON librenms. TO 'librenms'@'localhost';
FLUSH PRIVILEGES;
exit;

Enable auto-start and Restart MySQL

systemctl enable mariadb
systemctl restart mariadb