MYSQL is BROKEN fresh install

[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

[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....

[yoko eagle]

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.