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

How to Install Jenkins on CentOS 7?

Jenkins is an opensource and free tool for developers to develop, test and deploy the code...

How to Deploy Laravel Application with Nginx on Ubuntu?

Laravel is a PHP Framework and Nginx is a Web-Browser which can be installed on Ubuntu. Nginx is...

How to install/add Softaculous in Plesk?

Softaculous is software that auto-install web applications with one click. There is a wide range...

How to enable sFTP in a Linux VPS?

The SSH File Transfer Protocol (SFTP), also known as the Secure File Transfer Protocol, enables...

How To Add A New IP Address In Virtualmin?

You can add an IP Address via Networking Module directly with virtualmean. To do this, you need...

  • 0 Users Found This Useful

Was this answer helpful?