wait_timeout is the number of seconds the MySQL server waits for activity on a noninteractive connection before closing it. Some applications may ask for the wait_timeout to be increased in the database which the application is using so that MySQL doesn't drop the connections too soon.
Here we cover the steps to increase this value using phpMyAdmin.
Related Articles
Increase wait_timeout
- Log into cPanel
- Navigate to phpMyAdmin, located under the Databases section
- Select the database you wish to modify
- Click on Query at the top of the page
- Check the current settings by pasting the following into the query section:
SHOW SESSION VARIABLES LIKE "%wait_timeout%";
- Click Submit Query
- The query will execute and provide the following information:
- Click Submit Query
- To change the value of wait_timeout, paste the following into the query field and click Submit Query
SET session wait_timeout=300;
NOTE: 300 is used here as an example. You should adjust this value based on your application's needs. - Repeat Step 5 to confirm the value has changed