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

Necessary Checks :-

1. Check the status of MySQL service -
    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'
     That means your server has exceeded the limit of handling the MySQL connection.

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.

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 | |
-------------------------------------------------------------------------------------+-------------------------
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 connectionmax_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!

Was this answer helpful?

 Print this Article

Also Read

How to backup single MySQL table?

Backup single MySQL table using shell command and phpMyAdmin 1. Creating dump file -...

How to prevent xmlrpc attack on the WordPress?

To prevent xmlrpc attack in WordPress website just add below code to the .htaccess file of the...

FATAL: Failed to download updatenow.static from server: The system cannot update the /var/cpanel/sysinfo.config file. at /usr/local/cpanel/Cpanel/GenSysInfo.pm line 115 : upcp failed

You may come across the message "***** FATAL: Failed to download updatenow.static from server:...

A DNS entry for 'domain_name' already exists. You must remove this DNS entry from all servers in the DNS cluster to proceed.

While adding addon domain under cPanel, I was getting error as below - A DNS entry for...

How to allow remote MySql connection to only one IP?

There may be a case in which one of the cPanel user request you to provide access to Mysql...

Powered by WHMCompleteSolution