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 find all files larger than 1GB size in Linux?

If your server is running multiple applications, it could be run out of space at one point. When...

How to install Apache on Ubuntu?

Apache is one of the popular web servers. It has many strong features, including dynamic modules,...

How do I connect to Linux VPS through SSH from Linux and Windows OS?

This article will guide you on how to login to Linux VPS through SSH (Secure Shell) from Linux...

How To install Nginx on CentOS 7?

Nginx is a Web server that can be installed on Linux Server. You may have heard about Apache Web...

How to redirect http to https using .htaccess?

If you have installed SSL Certificate on your website and want to redirect your website traffic...

  • 0 Users Found This Useful

Was this answer helpful?