Page 1 of 1

MYSQL is BROKEN fresh install

Posted: Wed Apr 11, 2018 8:50 pm
by dovanele
Hi,

I happily used VestaCP for many years until recently after updated in 2 weeks constant crashed and and broken updates.

viewtopic.php?t=13363

I now have completely broken MYSQL, have reinstalled clean and backup, but after updates it's just same broken MYSQL. It's not possible to login to mysql
and if I try to change password it simly hangs after

Code: Select all

sudo mysqld --skip-grant-tables
next time i try to do it again it gives error

Code: Select all

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Funny that once i have managed to get it running with password changed but then it gone back to the same after few minutes

Also for variety it sometimes gives error

Code: Select all

mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
so i fix it with this

Code: Select all

mkdir -p /var/run/mysqld
chown mysql:mysql /var/run/mysqld
but then next time it all hangs again. It's like vicious wheel of errors that just keep circling round and round...

Is there something wrong with install? I newer have been stuck in such an endless loop before, have no idea what to do :(

ubuntu 16.04 64bit
latest vestacp from
# curl -O http://vestacp.com/pub/vst-install.sh

Re: MYSQL is BROKEN fresh install

Posted: Thu Apr 12, 2018 8:17 pm
by dovanele
I gave up on this and installed another fresh isntall and made sure password is set from install script as changing password for MYSQL is definition of impossible LMAO. Like seriously how it's possible to make most rudimentary task to make impossible it's beyond....

Re: MYSQL is BROKEN fresh install

Posted: Fri Apr 13, 2018 8:20 am
by yoko eagle
dovanele wrote:
Wed Apr 11, 2018 8:50 pm
Hi,

I happily used VestaCP for many years until recently after updated in 2 weeks constant crashed and and broken updates.

viewtopic.php?t=13363

I now have completely broken MYSQL, have reinstalled clean and backup, but after updates it's just same broken MYSQL. It's not possible to login to mysql
and if I try to change password it simly hangs after

Code: Select all

sudo mysqld --skip-grant-tables
next time i try to do it again it gives error

Code: Select all

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
In my experienced, it is because of the latest security applied on latest vestacp version.
It's tightening the password auth process.
I can resolved it by resubmit all db password on each db within vesta GUI.
Then restart mysql service.