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

Do You Provide GUI With VPS or Just a Command Line?

Yes, we do provide GUI environment with all our Windows VPS plans. However, in Linux VPS, you...

How to Safely Change the Location of MySQL/MariaDB Data Directory on cPanel/WHM Servers?

You may require to change the MySQL data directory due to insufficient partition space on /var or...

Will internal traffic between two VPS viz. a Database Server and a Web Server be counted in my bandwidth usage?

Yes it will. The traffic will be counted in the bandwidth usage of your VPS. Even if you use...

How to redirect http to https using .htaccess?

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

How to install IonCube Loader on CentOS 7 Manually?

Ioncube is a PHP module which protects the PHP application's source code from being viewed from...

  • 0 Users Found This Useful

Was this answer helpful?