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 Configure Redis Caching to Speed Up WordPress on Ubuntu 18.04?

Redis is an open-source in-memory data structure store. It can be used as a DB and cache. It...

How to List All Files Ordered by Size in Linux?

In Linux, we can list all the files using the ls command. Here, we will share some commands which...

How to allow or block the port and IP Address using Firewalld, IP tables, and UFW in Linux?

On Linux, the firewall is essential to control the incoming and outgoing network traffic. It is...

How to install Virtualmin / Webmin control panel in Ubuntu 18.04?

Please refer to the following steps to install Webmin/Virtualmin on Ubuntu 18.04 Let's run the...

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...

  • 0 Users Found This Useful

Was this answer helpful?