Add a NEW DB to the default MariaDB install

[chris_hird]

We have a default install of MariaDB on our NagiosXI server. I am trying to add a new database to the MariaDB instance which will hold content that we want to be able to pull down via a Web interface. The problem is when we try to create the new database none of the users we have tried have the authority to add the new database? We have identified the users that Nagios creates by default, (nagiosxi,nagiosql,ndoutils,dbmain_nagiosxi) all of which cannot create a new database? We are using Ubuntu so we have also tried to run via sudo and even enabled root and run su then tried to access using mysql -uroot -p. Everything seems to end up with access denied, or select denied etc. Does anyone know the correct user that has the ability to create a new database?

Thanks in advance

Chris...

[chris_hird]

OK I found out how to get the root password set for the db using /usr/local/nagiosxi/scripts/get_mysql_passwords.sh. I can now do everything that is needed.

Chris...