Mysql - login failed

Hi,

got to the post-installation wizard and I get this message:

Login failed : Incorrect administration username or password

I am using the same root user and pass, I also tried to change them in the mysql database server area in the options and also using the command shell. I've seen people have the issue before and i can't seem to get any of the fixes to work! :-(

Status: 
Active

Comments

Howdy -- just to clarify, are you saying that there is a MySQL password already set?

The post-install wizard is assuming that there is no password set yet.

unborn's picture
Submitted by unborn on Tue, 06/07/2016 - 09:47 Pro Licensee

Hi guys, been setting up 3 new virtualmin installs based on debian.. had exactly same issue.. what I had to do is put sql into safe mode and then reset root password via terminal.. then it worked..

In this case, is there a MySQL root password that's set though. prior to when Virtualmin is run?

FYI, in the next Virtualmin release, if the post-install wizard doesn't know your mysql password it will prompt the admin to enter it.

unborn's picture
Submitted by unborn on Tue, 06/28/2016 - 12:04 Pro Licensee

Update...

I just tested this on 17 installs and seems to me that issue is gone.

We're glad to hear it's working better!

We had been seeing that problem more often lately, and Jamie has made some changes to help out with that problem.

I have tried to install virtualmin pro on a fresh install of Centos 7.2, and mysql login failed. I also had to stop mysql, put it in safe mode, then change the root passward, stop mysqld and restart it again. Then use the webmin panel to change all the root passwords. The install script never asked for a root mysql password, so it failed in the post installation script.

Did you have a root password that was set on your installation there?

The next Virtualmin version to be released should handle that better, and will ask during the setup process if there's an existing password, rather than assuming that there is none.

Is it working for you now though?

I had never set a mysql password. I installed Centos 7.2 from the minimal ISO, then upgraded it to the Base configuration, then installed Webmin. So, it was a fresh Centos install with no mods except to upgrade with groupinstall "Base"