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.
New VestaCP instl. Can't cnect to mysql in panel/phpmyadmin
New VestaCP instl. Can't cnect to mysql in panel/phpmyadmin
Brand new VestaCP install. Can't create database in panel, gives connection error. Phpmyadmin gives #2002 error when using correct password. Got password from vesta conf files. Both passwords match in both /root/my.cnf and mysql.conf.
......what next?
Edit: Also, running 'mysql' from the root prompt gets this response..
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
......what next?
Edit: Also, running 'mysql' from the root prompt gets this response..
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Re: New VestaCP instl. Can't cnect to mysql in panel/phpmyad
What happens when you run this,MartyGC wrote:Brand new VestaCP install. Can't create database in panel, gives connection error. Phpmyadmin gives #2002 error when using correct password. Got password from vesta conf files. Both passwords match in both /root/my.cnf and mysql.conf.
......what next?
Edit: Also, running 'mysql' from the root prompt gets this response..
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Code: Select all
service mysql restart
Re: New VestaCP instl. Can't cnect to mysql in panel/phpmyad
It restarts perfectly normal :(
root@v######:~# service mysql restart
mysql stop/waiting
mysql start/running, process 22026
root@v######:~#
The VPS had been freshly installed prior to the VestCP install. So I'm really unsure how/what could have gone wrong.
Path to where I am:
Re Installed ubuntu 14.04 minimal i386 from VPS control panel.
Logged in as root, changed hostname & /etc/host to reflect real world address.
Installed VestaCP, followed instructions on Docs page. Seems to complete with no errors. Admin user works, the CP login works.
Retrieved mysql password that was auto generated by VestaCP conf(confirmed password in /root/my.cnf and mqsql.conf)
Try to create DB through VestaCP: Connection error
Try to login through phpmyadmin: error #2002.
And thats where I'm stuck at.... Its on a VPS from Vultr.com if that matters??
Thanks :)
root@v######:~# service mysql restart
mysql stop/waiting
mysql start/running, process 22026
root@v######:~#
The VPS had been freshly installed prior to the VestCP install. So I'm really unsure how/what could have gone wrong.
Path to where I am:
Re Installed ubuntu 14.04 minimal i386 from VPS control panel.
Logged in as root, changed hostname & /etc/host to reflect real world address.
Installed VestaCP, followed instructions on Docs page. Seems to complete with no errors. Admin user works, the CP login works.
Retrieved mysql password that was auto generated by VestaCP conf(confirmed password in /root/my.cnf and mqsql.conf)
Try to create DB through VestaCP: Connection error
Try to login through phpmyadmin: error #2002.
And thats where I'm stuck at.... Its on a VPS from Vultr.com if that matters??
Thanks :)
Re: New VestaCP instl. Can't cnect to mysql in panel/phpmyad
FIXED:
Everything began working after I ran 'apt-get build-dep mysql-server'.
Everything began working after I ran 'apt-get build-dep mysql-server'.