We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
MYSQL is BROKEN fresh install
MYSQL is BROKEN fresh install
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
next time i try to do it again it gives error
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
so i fix it with this
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
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
Code: Select all
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Also for variety it sometimes gives error
Code: Select all
mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
Code: Select all
mkdir -p /var/run/mysqld
chown mysql:mysql /var/run/mysqld
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
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....
-
- Posts: 33
- Joined: Sat Jan 20, 2018 3:45 am
- Os: Debian 8x
- Web: apache + nginx
Re: MYSQL is BROKEN fresh install
In my experienced, it is because of the latest security applied on latest vestacp version.dovanele wrote: ↑Wed Apr 11, 2018 8:50 pmHi,
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 afternext time i try to do it again it gives errorCode: Select all
sudo mysqld --skip-grant-tables
Code: Select all
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
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.