How to increase MySQL Connections limit

If you need to increase MySQL Connections without MySQL restart do below step, also if you don't know configuration file, below use the MySQL workbench or PHPMyAdmin or command prompt to run below queries.

mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 151   |
+-----------------+-------+
1 row in set (0.00 sec)

mysql> SET GLOBAL max_connections = 250;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 250   |
+-----------------+-------+
1 row in set (0.00 sec)

These settings will change at MySQL Restart.

  • 3 Users Found This Useful
Was this answer helpful?

Related Articles

How to access phpMyAdmin directly without cPanel access?

In this tutorial, I’m going to share the steps in installing PhpMyAdmin on your web hosting...

How to Install Imagick on cPanel Server

To install Imagick first install ImageMagick on the server. Learn how to install Imagick on...

How to Install Memcached on cPanel Server

Install Memcache on CentOS (WHM/cPanel) Step 1: Login into your WHM panel and using...

PHP Max Execution Time Setting on cPanel Server

 How to set PHP max execution time on cPanel. A quick step by step guidelines for new learners....

How to Install NGINX on cPanel/WHM Server

Learn how to install NGINX on cPanel Server following tutorial. Installing NGINX is very easy...

Powered by WHMCompleteSolution