When the MySQL service on the VPS is dead, we visit the website on the browser we will see error:
![https://vpssim.vn/wp-content/uploads/2014/12/loi-Error-establishing-a-database-connection.png](https://vpssim.vn/wp-content/uploads/2014/12/loi-Error-establishing-a-database-connection.png)
To fix this error, we should start MySQL service:
The function path: VPSSIM menu ==> Database manage ==> Auto re-Start MySQL Server
To enable this function:
![https://vpssim.vn/wp-content/uploads/2014/12/loi-Error-establishing-a-database-connection.png](https://vpssim.vn/wp-content/uploads/2014/12/loi-Error-establishing-a-database-connection.png)
To fix this error, we should start MySQL service:
Code: Select all
or on centos 7:service mysql start
Code: Select all
We can config VPSSIM auto do this by using the function: Auto re-Start MySQL Serversystemctl start mysql.service
The function path: VPSSIM menu ==> Database manage ==> Auto re-Start MySQL Server
To enable this function:
========================================================================= VPSSIM - Manage VPS/Server by VPSSIM.COM (4.5.0.8) ========================================================================= Database Manage ========================================================================= Total Databases Size: 50M | Total Backup Files Size: 13M ========================================================================= How to use: http://go.vpssim.vn/howdata ========================================================================= 1) Create Database 9) Copy Backup To Root Of Domain 2) Delete Database 10) Delete All Backup Files 3) Backup 1 Database 11) View Database's Infomation 4) Backup All Databases 12) View MySQL Root's password 5) Backup & Restore FULL (1 File) 13) Re-Config MySQL 6) Auto Backup Database 14) Auto re-Start MySQL Server 7) Restore Database 15) List & Size of All Databases 8) Get Link Download Backup Type in your choice (0-Exit): 14 ========================================================================= With less RAM server, sometime free RAM is too low, MySQL service is stop ------------------------------------------------------------------------- After you enable [Auto re-start MySQL Server] function ------------------------------------------------------------------------- VPSSIM will check MySQL status every 5 minutes, If MySQL service stop ------------------------------------------------------------------------- VPSSIM will re-Start it within a maximum of 5 minnutes. ========================================================================= How to use: http://go.vpssim.vn/autostartmysql ========================================================================= You want to enable [Auto re-start MySQL Server] function ? [y/N] yResult:
========================================================================= Enable [Auto re-start MySQL Server] function successfully ! ========================================================================= VPSSIM - Manage VPS/Server by VPSSIM.COM (4.5.0.8) ========================================================================= Database Manage ========================================================================= Total Databases Size: 50M | Total Backup Files Size: 13M ========================================================================= How to use: http://go.vpssim.vn/howdata ========================================================================= 1) Create Database 9) Copy Backup To Root Of Domain 2) Delete Database 10) Delete All Backup Files 3) Backup 1 Database 11) View Database's Infomation 4) Backup All Databases 12) View MySQL Root's password 5) Backup & Restore FULL (1 File) 13) Re-Config MySQL 6) Auto Backup Database 14) Auto re-Start MySQL Server 7) Restore Database 15) List & Size of All Databases 8) Get Link Download Backup Type in your choice (0-Exit):To disable this function, we run this function once again.
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)