Plesk Backup Error : Failed to connect to database: User admin already has more than ‘max_user_connections’ active connections

• 22 September 2021
• in: Tech Support

Failed to connect to database: User admin already has more than ‘max_user_connections’ active connections

You’d sometimes get this error once the maximum allowable connection limit to the database is earned. It also implies that the database already has enough number of connections and can’t enable anymore. In that case you will either stay up for someone to disconnect OR if incase a specific script has opened too several connections to the database all at once.

Solution

In such a case, you must these simple steps as mention below:

Step 1: RDP into the windows server.

Step 2: Edit the file C:\Program Files\Paralles\Plesk\MySQL\Data\my.ini

In this file explore for the maximum set limit under settings max_user_connections. You will either select to increase the value OR remove the max_user_connections parameter.

Note: Removal of the max connections parameter would build the default mysql settings to be applied to the database.

If you face any problems there upon, please contact us via. Live Chat or raise a ticket. We are ready to help.