How to change the MySQL timeout limit in Linux?

Please refer to the following article to change the MySQL timeout error. 

  1. Log in to your server root or sudo user using Secure Shell. 

  2. Open the MySQL configuration file my.cnf with your favorite editor.

    $ sudo vi /etc/my.cnf
  3. Find the timeout configuration in my.cnf and change the required setting.

    wait_timeout = 2880
    interactive_timeout = 2880
  4. Save and close your my.cnf file. 

  5. Restart your MySQL service to apply your changes.
     
    $ sudo /etc/init.d/mysql restart

Related Articles

Fix cPanel Error -The Email Account Already Exists

Sometimes, you add an email account from cPanel, and you get an error message The Email Account...

How to use the Rsync command in linux?

Rsync is an important command in Linux and used to synchronize or copy the files and directories...

How to Install and Configure the HAProxy on CentOS?

HAProxy is a very fast and decent tool to achieve high availability, load balancing. It can work...

How to Stop and Disable ClamAV Service from CentOS?

We all know that ClamAV scanner is pretty heavy on CPU-Memory resources, and it should be avoided...

How To Install EPEL Repo on CentOS and RHEL 7?

EPEL stands for Extra Packages for Enterprise Linux. It is very easy to install additional...

  • 0 Users Found This Useful

Was this answer helpful?