No announcement yet.

Backup error: Failed to connect to database

  • Filter
  • Time
  • Show
Clear All
new posts

  • Backup error: Failed to connect to database

    If you are using Windows server with MySQL and Parallels Plesk control panel and while trying to get backup receiving following error type:

    Failed to connect to database: User admin already has more than ‘max_user_connections’ active connections.
    It means there is restriction for maximum number of connections to the database and they are all already used. So, no more connections can be opened. To get rid of this error you will have to close previous connections which are still open.

    Solution: -

    RDP into Windows Server

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

    Check the settings max_user_connections and increase the value or better remove the max_user_connections parameter and mysql default settings will be applied.