Question
Adding database → Error: Connection failed on VestaCP
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!
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.
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 !