Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

New VestaCP instl. Can't cnect to mysql in panel/phpmyadmin

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
4 posts • Page 1 of 1
MartyGC
Posts: 3
Joined: Mon Jan 05, 2015 2:48 pm

New VestaCP instl. Can't cnect to mysql in panel/phpmyadmin
  • Quote

Post by MartyGC » Mon Jan 05, 2015 2:57 pm

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

joem
Posts: 378
Joined: Thu Nov 13, 2014 8:33 am

Os: CentOS 6x
Web: nginx + php-fpm
Re: New VestaCP instl. Can't cnect to mysql in panel/phpmyad
  • Quote

Post by joem » Mon Jan 05, 2015 7:11 pm

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,

Code: Select all

service mysql restart
Top

MartyGC
Posts: 3
Joined: Mon Jan 05, 2015 2:48 pm

Re: New VestaCP instl. Can't cnect to mysql in panel/phpmyad
  • Quote

Post by MartyGC » Mon Jan 05, 2015 10:03 pm

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

MartyGC
Posts: 3
Joined: Mon Jan 05, 2015 2:48 pm

Re: New VestaCP instl. Can't cnect to mysql in panel/phpmyad
  • Quote

Post by MartyGC » Tue Jan 06, 2015 5:55 am

FIXED:

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


Post Reply
  • Print view

4 posts • Page 1 of 1

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

cron

Login  •  Register

I forgot my password