MySQL Install Error

Submitted by JackB on Sat, 07/30/2016 - 02:08

Hi,

Went to install Virtualmin pro on a Debian 8 box, upon entering the configuration dialog it is impossible to login to MySQL and set the password. Have tested it 3 times on a VM.

Regards

Status: 
Active

Comments

Submitted by JackB on Sat, 07/30/2016 - 02:09

I forgot to paste the following error.

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

Submitted by JackB on Sat, 07/30/2016 - 02:25

I solved it by running the following after SSHing in.

sudo /etc/init.d/mysql stop

then

sudo mysqld_safe --skip-grant-tables &

then

mysql -uroot

then

use mysql;

update user set password=PASSWORD("somenewpass") where User='root';

flush privileges;

quit

then

sudo /etc/init.d/mysql stop

then

sudo /etc/init.d/mysql start

Submitted by andreychek on Sat, 07/30/2016 - 08:45

Glad to hear you got things working!

Was there a MySQL password already set, prior to Virtualmin running?

We have been seeing more folks run into this issue though, and the next Virtualmin version will handle this case better.

Submitted by JackB on Sat, 07/30/2016 - 13:07

No it was a fresh install of debian without mysql - with mysql installed by your script.