{"id":2163,"date":"2021-09-22T12:45:17","date_gmt":"2021-09-22T12:45:17","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=2163"},"modified":"2021-09-22T12:45:17","modified_gmt":"2021-09-22T12:45:17","slug":"plesk-backup-error-failed-to-connect-to-database-user-admin-already-has-more-than-max_user_connections-active-connections","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/plesk-backup-error-failed-to-connect-to-database-user-admin-already-has-more-than-max_user_connections-active-connections\/","title":{"rendered":"Plesk Backup Error : Failed to connect to database: User admin already has more than \u2018max_user_connections\u2019 active connections"},"content":{"rendered":"<h2><strong>Failed to connect to database: User admin already has more than \u2018max_user_connections\u2019 active connections<\/strong><\/h2>\n<p>You\u2019d 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&#8217;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.<\/p>\n<h2>Solution<\/h2>\n<p>In such a case, you must these simple steps as mention below:<\/p>\n<p>Step 1: <strong>RDP<\/strong> into the windows server.<\/p>\n<p>Step 2: Edit the file <strong>C:\\Program Files\\Paralles\\Plesk\\MySQL\\Data\\my.ini<\/strong><\/p>\n<p>In this file explore for the maximum set limit under settings<strong> max_user_connections<\/strong>. You will either select to<strong> increase the value OR remove the max_user_connections parameter.<\/strong><\/p>\n<p><strong>Note:<\/strong> Removal of the max connections parameter would build the default mysql settings to be applied to the database.<\/p>\n<p>If you face any problems there upon, please contact us via. Live Chat or raise a ticket. We are ready to help.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Failed to connect to database: User admin already has more than \u2018max_user_connections\u2019 active connections You\u2019d 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&#8217;t enable anymore. In that case you will either stay up for [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[],"class_list":["post-2163","post","type-post","status-publish","format-standard","hentry","category-tech-support"],"_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=2163"}],"version-history":[{"count":1,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2163\/revisions"}],"predecessor-version":[{"id":2164,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2163\/revisions\/2164"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=2163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=2163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=2163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}