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

VSFTPD is an FTP server for Unix/Linux systems. It is a default FTP server on CentOS, RHEL Linux...

How to Install and configure Dovecot on CentOS?

Dovecot is used to receive incoming emails on your server from Postfix. Dovecot is an open-source...

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

How to take Backup of Exim Configuration from WHM?

EXIM comes with cPanel which is responsible for the email tranfer on the Linux server. Users can...

  • 0 Users Found This Useful

Was this answer helpful?