Maria db denying access to user 'root' @ 'localhost'

Virtualmin
1
SYSTEM INFORMATION
OS type and version ubuntu 22.04
Webmin version 2.202
Virtualmin version 7.30.4
Webserver version assuming this means usermin? 2.102
Related packages php8.1, mariadb11.2

I know this has been asked before, but nothing i’ve tried has been working.
When i try to access mautic files via visiting the website holding it, i get an error. i believe this is being caused by the error:


ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

i have tried every combination of user and password i can think of (including the ones for virtualmin, the password listed in the mariadb password, the username as the start of my domain, the username as my ssh login)
not trying to repeat previous questions but i honestly feel like i’m banging my head into a brick wall. I have been attempting to log in via ssh and via webmin, and attempted to change the password of the mariadb database from virtualmin, but nothing will go through- just keep getting

The full MariaDB error message was : DBI connect failed : Access denied for user 'root'@'localhost' (using password: YES) ?

any help would be appreciated greatly.

2

Databases are a particularly weak area for me. That said.
Rather than try random users, who is the database installed under?

image
image1046×539 68.7 KB

3

Thanks for the suggestion! I don’t appear to have the same options on my webmin, i can go into servers>mySQL database server
at this point i get the error that
Warning! Webmin needs to know your MariaDB administration login and password in order to manage your database. Please enter your administration username (usually root) and password below.
followed by the mariaDB error message.

when i go into configuration > server connection, the administration login is set to root (as opposed to default). i have then gone into change passwords, and ensured the password is definitely the one i have been using. The login still will not work. any ideas? completely appreciate this may not be your forte but you’re definitely still miles ahead of me.

4

Was this database set up during the installation of Mautic? Maybe check the config files there.

Does the program work?

5

it was the one set up during installation (i set the password) but then i needed to upgrade it for my uses. does this change anything?

6

i can now log onto mariadb via ssh, but it still will not work via virtualmin. slightly stuck on how to fix this

eta: i can log on once on a fresh installation, but then any subsequent attempts return the error 1045

7

You have to be putting in a incorrect passsword in webmin, when you enter don’t cut and paste the password just in case your copy a white space.

image
image1507×554 55.5 KB

you can check /etc/webmin/mysql/config to view what password webmin is using.

8

this is genuinely only getting stranger. I have attempted ssh login using the exact password that i have set/checked. this password is the one in the config file. the access denied error is continuing on ssh, and incorrect user/password when i try via webmin. next step will probably be to try and change the password via virtualmin, but not holding out much hope. any more thoughts?

9

You mean your ssh login fails as well as mariadb?
Fail2ban maybe blocking you.
What do you mean in the config file?

10

yeah both are failing. and sorry for the confusion- i meant double checked the password webmin has been using is the right one (/etc/webmin/mysql/config). I also managed to set the mariadb password in safe mode again to the one i am using just in case there was an error with it but no joy.