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 set Automate Tasks on a Linux VPS Using Cron?

One of our Linux VPS customers faced an issue wherein his Virtual Machine’s system clock was...

How to Install a Perl Module in cPanel?

Perl module allows adding the custom functionality to cPanel & WHM server. Please refer to...

How To Install Postfix on Ubuntu 18.04?

Postfix is an open-source Mail Transfer Agent (MTA). It uses to route and deliver emails on a...

How to Switch Web Server from Apache to LiteSpeed on WHM?

Apache and LiteSpeed both are the WebServers. Apache is older and popular compared to LiteSpeed....

How can I view my website before DNS changes?

Before DNS propagation takes place, you can browse your website wite temporary URL. Following are...

  • 0 Users Found This Useful

Was this answer helpful?