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 Enable Root User in Ubuntu Server?

Please refer to the below steps to enable root user in ubuntu. Login to your ubuntu server...

How to Install a Perl Module in cPanel?

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

How to enable error-log.txt logging using .htaccess file?

You need to add the below lines in .htaccess file if you want your PHP errors within the...

5 Wget Command Examples to Download Files in Linux.

wget is used to download your files from the remote server. It is used mostly on Linux...

  • 0 Users Found This Useful

Was this answer helpful?