Post installation wizard MYSQL connection failed

Hi

While running the post installation wizard, I have this error just after the step where it asks to set a password for the MYSQL root user :

DBI connect failed : Access denied for user ‘root’@‘localhost’ (using password: NO)

I set a password, but I get this error.

I have reinstalled my VPS, reinstalled Virtualmin, but the error is still here.
My VPS runs on CentOS 7

Any idea ?

Thx

Hey,

The issue is not related to your VPS as the error message says DBI connect. Can you change your MySQL Database password?Try doing that and continue with installation.

Regards,

The step of the wizard before I get this error is where I define a new password.

Maybe there is an issue with the wizard … I just tried to change the password with the command line :

[root@vps ~]# /usr/bin/mysqladmin -u root password 'XXXXXXXXX' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'

MariaDB is running, but it seems that the server is not accessible.

Hey…

Are you able to access virtualmin with the current password and the user as root?

If yes, you could login to it and check for the MySql DB and change the password there. It could be an issue with accessing the password for the root user with the MySql DB. Before continuing the post installation wizard, directly go into the Db list and change the password in the field and then log out and continue. I had the same issue a few days back and did the above steps to resolve it.

Do lemme know if this helps!!!