bigdropgr
By:
bigdropgr

Adding database → Error: Connection failed on VestaCP

February 17, 2015 8.1k views

Hi, on my droplet (2Gb ram, Ubuntu 14.04) I've installed the VestaCP (it is my 8th droplet on which I use VestaCP). I have added two databases and two sites. Everything looks as usuall but today when I tried to add a third database I get an error "Adding database → Error: Connection failed" plus that the existing databases were not running.
I tried changing the password in the /usr/local/vesta/conf/mysql.conf file and the existing databases worked but I still cannot add new database.

Can anyone help please?
Thank you in advance!

6 comments
  • Is anything reported in your log files when the MySQL service ceases to respond? Also, when MySQL is running with your two databases what is the output of "free -m" on your droplet? The most common reason for MySQL to stop responding is running out of available memory for the process.

  • Hi, the output of the free-m is here http://tinypic.com/r/sy8imd/8, there are no logs in the vestacp.
    In the past I had even 5 databases on one droplet with 512 ram (on a test droplet) with no problem at al.

  • This may sound silly, but have you tried restarting MySQL in VestaCP Services? I also found creating a swapfile (https://www.digitalocean.com/community/tutorials/how-to-add-swap-on-ubuntu-14-04) helped prevent MySQL from crashing (related to the free memory).

  • b'coz u change phpmyadmin root password manually in terminal. so.. if you create db in vesta panel not connect.

  • When i restart server, will get this Error: Connection failed on VestaCP,
    Login to vestacp > Services > Restart mysql
    It work for me

    Good luck

  • Hello Prajya My Problem Successfull Thank You !

1 Answer

This question was answered by @Prajya:

When i restart server, will get this Error: Connection failed on VestaCP,
Login to vestacp > Services > Restart mysql
It work for me

Good luck

You can see the comment here.

Have another answer? Share your knowledge.