{"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"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Plesk Backup Error : Failed to connect to database: User admin already has more than \u2018max_user_connections\u2019 active connections - OWS KB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ownwebservers.com\/kb\/plesk-backup-error-failed-to-connect-to-database-user-admin-already-has-more-than-max_user_connections-active-connections\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Plesk Backup Error : Failed to connect to database: User admin already has more than \u2018max_user_connections\u2019 active connections - OWS KB\" \/>\n<meta property=\"og:description\" content=\"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;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/plesk-backup-error-failed-to-connect-to-database-user-admin-already-has-more-than-max_user_connections-active-connections\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-22T12:45:17+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"admin\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"1 minute\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"OWS KB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/plesk-backup-error-failed-to-connect-to-database-user-admin-already-has-more-than-max_user_connections-active-connections\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/plesk-backup-error-failed-to-connect-to-database-user-admin-already-has-more-than-max_user_connections-active-connections\/\",\"name\":\"Plesk Backup Error : Failed to connect to database: User admin already has more than \\u2018max_user_connections\\u2019 active connections - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"datePublished\":\"2021-09-22T12:45:17+00:00\",\"dateModified\":\"2021-09-22T12:45:17+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/plesk-backup-error-failed-to-connect-to-database-user-admin-already-has-more-than-max_user_connections-active-connections\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/plesk-backup-error-failed-to-connect-to-database-user-admin-already-has-more-than-max_user_connections-active-connections\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/plesk-backup-error-failed-to-connect-to-database-user-admin-already-has-more-than-max_user_connections-active-connections\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/plesk-backup-error-failed-to-connect-to-database-user-admin-already-has-more-than-max_user_connections-active-connections\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/plesk-backup-error-failed-to-connect-to-database-user-admin-already-has-more-than-max_user_connections-active-connections\/\",\"name\":\"Plesk Backup Error : Failed to connect to database: User admin already has more than \\u2018max_user_connections\\u2019 active connections\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ownwebservers.com\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_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}]}}