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 ISPConfig on CentOS 7.x?

ISP config is an open-source control panel for Linux with easy to use web interface that helps...

Can I open APN port 2195 on my VPS?

You will get full administrative control of your VPS, therefore you can surely open/close any...

How to use the Rsync command in linux?

Rsync is an important command in Linux and used to synchronize or copy the files and directories...

How to disable anonymous ftp in cpnael?

Note : It is not recommended to use anonymous FTP. It allows any person to access FTP without...

How to Install phpMyAdmin on CentOS 7?

phpMyAdmin is a web-based GUI tool to manage your MySQL and MariaDB Databases. It is an...

  • 0 Users Found This Useful

Was this answer helpful?