MySQL server is currently offline. Error: Too many connections at /usr/local/cpanel/Cpanel/Mysql.pm line 173.

phpMyAdmin and MySQL Databases in cPanel were displaying me the below error –

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

==============================================================

1. Check the status of MySQL service –
    service mysql status
    Output – SUCCESS! MySQL running (515897)

 2. Check the current MySQL processes on server –
     mysqladmin pr
     Output – mysqladmin: connect to server at ‘localhost’ failed
     error: ‘Too many connections’

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.

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 | |
————————————————————————————-+————————-

If you’d like to kill process ‘539054’ then fire – kill 539054

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