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

What if I exceed the bandwidth limit I am assigned with VPS?

Our system continually monitors the bandwidth usage of all our VPS. In case if your total monthly...

How to reset MySQL 8.0 root password on Centos 7.x?

You may need to reset your MySQL root password if you lost or forget it. MySQL stores the...

bash: netstat: command not found.

You may face the below error on your Linux OS if you haven’t installed the netstat command...

How to Run Multiple PHP versions with Nginx on Ubuntu?

You can run multiple php versions on Ubuntu without any issue. You require Multiple php versions...

Fix Exim error-exim dead but subsys locked

Problem Statement php mail scripts were not working in Linux VPS. Error Message exim dead but...

  • 0 Users Found This Useful

Was this answer helpful?