Plesk (windows) backup gives the error: Failed to connect to database: User ‘admin’ has exceeded the ‘max_user_connections’ resource (current value: 10)

when you try to backup the databases of the websites from Plesk Backup util and you get failure and the message “Failed to connect to database: User ‘admin’ has exceeded the ‘max_user_connections’ resource (current value: 10)” you have to change the mysql options

In order to pass through this you have to edit the my.ini of plesk’s mysql (the first line would be something like “[PleskSQLServer]”)  and add the following line

set-variable=max_user_connections=20

increase the number as you like in order to make it work.

Restart MySQL after my.ini is modified.