phpMyAdmin and MySQL Databases in cPanel were displaying me the below error -
==============================================================
The MySQL server is currently offline.
The MySQL server is currently offline.
Error while connecting to MySQL: (XID 98u48v) Database Connect Error: Too many connections Error while connecting to MySQL: (XID 98u48v) Database Connect Error: Too many connections at /usr/local/cpanel/Cpanel/Mysql.pm line 173.
==============================================================
Sites on server were down with error as - Error establishing a database connection
==============================================================
Necessary Checks :-
1. Check the status of MySQL service -
service mysql status
Output - SUCCESS! MySQL running (515897)
service mysql status
Output - SUCCESS! MySQL running (515897)
MySQL service was running without any issue.
2. Check the current MySQL processes on server -
mysqladmin pr
Output - mysqladmin: connect to server at 'localhost' failed
error: 'Too many connections'
mysqladmin pr
Output - mysqladmin: connect to server at 'localhost' failed
error: 'Too many connections'
That means your server has exceeded the limit of handling the MySQL connection.
Solutions :-
Solutions :-
1. You can kill the current running MySQL processes forcefully using -
1. mysqladmin pr ------------------> It will list the current running process.
2. kill process id --------------------> Kill the current processes using their ID.
2. kill process id --------------------> Kill the current processes using their ID.
Below is the example for you -
If you'll fire 'mysqladmin pr' then output will be as follow -
-------------------------------------------------------------------------------------+-------------------------
| Id | User | Host | db | Command | Time | State | Info +--------+------------------+-----------+-------------------+---------+------+----------------+----------
539054 | user_name | localhost |user_name | Sleep | 2 | |
-------------------------------------------------------------------------------------+-------------------------
| Id | User | Host | db | Command | Time | State | Info +--------+------------------+-----------+-------------------+---------+------+----------------+----------
539054 | user_name | localhost |user_name | Sleep | 2 | |
-------------------------------------------------------------------------------------+-------------------------
If you'd like to kill process '539054' then fire - kill 539054
Still you're facing the same issue then move to step 2.
2. Update the maximum number of connection allowed on server. Default value is set to 151, you can update according your server capability.
1. Edit my.cnf file on location - /etc/my.cnf or /etc/mysql/my.cnf
2. Update the maximum number of connection - max_connections=xxx ------> Replace xxx value as per your need
3. Restart the MySQL service - /etc/init.d/mysql restart OR service mysql restart
2. Update the maximum number of connection - max_connections=xxx ------> Replace xxx value as per your need
3. Restart the MySQL service - /etc/init.d/mysql restart OR service mysql restart
It resolved my issue!
