Mariadb Locked out on localhost

Community Support Database
1

Have an unusual issue with my server, where I am unable to access the db via localhost, it exists, it is running, and it has the port open, but whenever i try to connect, I get access denied.

The /usr/local/hestia/conf/mysql.conf shows correct users, and the root credentials are also access denied. Cannot get in to administer a database.

Help!

2

Show the versions of the software and the OS:

curl -fsSLm15 https://7j.gg/hcpver | bash -s --

What’s the exact error when executing this command from root?

mariadb -uroot -e 'SELECT user,host,plugin FROM mysql.user;'

What’s the mariadb status?

systemctl status mariadb --no-pager -l