Vesta Control Panel - Forum

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)

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)

What happens when you run this,

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 :)

FIXED:

Everything began working after I ran 'apt-get build-dep mysql-server'.