Turns out that the default installation of MariaDB sets the root user as identified by SOCKET and so
the ‘root’@‘password’ formulation in the script and the cnf file cannot work.
A separate ADMIN user needs to be created per
" ```
CREATE USER admin@localhost IDENTIFIED BY ‘password’;
GRANT ALL ON *.* TO admin@localhost WITH GRANT OPTION;
((note that the asterisks needed an escape to be displayed, which you’d not want in the actual cmd))
This allows librenms to access the DB using ‘admin’@‘localhost’ in place of root.
Using the new “admin” user works.
Data is coming through now.