New Icinga 2 setup, stuck on Icinga Web Database Setup

Icinga 2
1

I’m on a VM with a clean install of Ubuntu 24.04 installing a master of Icinga2, following the instructions on the icinga website to install.

Everything was going fine (relatively), got the icingaweb setup going, get to the ‘Database Setup’ part, the resource name is “icingaweb_db”, type: MySQL, host: localhost, database name “icingaweb_db”, I originally put in the icingaweb_db user account that was created earlier, it didn’t like it. Then I tried the “local” user I created that has sudo permissions in Ubuntu, it didn’t like that either. I then re-enabled the root account and tried that too, it STILL doesn’t like it.
I always get to the next page where it says “It seems that either the database you defined earlier does not yet exist and cannot be created…” and then gives me another credential area, where I can put in the credentials again and no matter what credentials I use, I get "access denied for user ‘root’ (or whatever I’m trying)@localhost.

The ‘local’ user is the one I used to create the databases earlier in the process, so I know it works & has the right permissions in MySQL, what’s going on??? How do I get through this?

2

I also just now created a new user in MySQL, gave it Create/etc permissions for all databases, tested those permissions, then went back into the Icingaweb setup, put in that user, clicked ‘next’ and same damn thing.
What now???

3

I saw another post somewhere on Git where they said the icingaweb setup doesn’t like DB’s with an “_” in the name, do my db name “icingaweb_db” would be the cause of the problem, but I took the _ out and made it just “icingawebdb” and it STILL doesn’t work. I’m completely lost here.

4

I guess there is a problem with the users greated in Mariadb/MySQL. Please review the database users ( for example with show grants; ).