Question

Adding database → Error: Connection failed on VestaCP

  • Posted February 17, 2015

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!

Subscribe
Share

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 !

This comment has been deleted

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

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

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.

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.


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

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.