Why does MySQL lost connection?

How do I fix failed to connect to MySQL?

MySQL default port is 3306 but it may be unavailable for some reasons, try to restart your machine. Also sesrch for your MySQL configuration file (should be called "my. cnf") and check if the used port is 3306 or 3307, if is 3307 you can change it to 3306 and then reboot your MySQL server.

How do I fix failed to connect to MySQL too many connections?

Solution1Identify the max_connections variable value: mysql --user="root" --password="PASSWORD" --execute='SHOW VARIABLES LIKE "max_connections"; ... 2Use your favorite text editor to change /etc/mysql/my.cnf and set the following values: max_connections = 500. ... 3Restart the MySQL service and to apply the changes.

How do I keep MySQL alive?

Tungsten Connector: Keep-Alives To prevent these connections being automatically closed, the connector can be configured to keep the connection alive by submitting a simple SELECT statement (actually SELECT 'KEEP_ALIVE';) periodically to ensure that the MySQL timeout is not reached and the connection closed.