{"id":5035,"date":"2016-08-22T07:48:40","date_gmt":"2016-08-22T07:48:40","guid":{"rendered":"https:\/\/cpanelplesk.com\/wp62\/?p=5035"},"modified":"2021-02-03T11:05:21","modified_gmt":"2021-02-03T11:05:21","slug":"plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections","status":"publish","type":"post","link":"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-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":"<p>Usually this error occurs when the maximum allowed connection limit of the database has exceeded. It also means that the database already has enough number of open connections and cannot allow anymore. In that case you can either wait for someone to disconnect or if incase a specific script has opened too many connections to the database all at once.In such a scenario, you must follow these simple steps :<!--more--><\/p>\n<p><strong>Step 1-<\/strong> Login into windows server using RDP.<\/p>\n<p><strong>Step 2-<\/strong> Edit the file:<\/p>\n<div class=\"error-sh\">\n<pre class=\"lang:default decode:true \">C:\\Program Files\\Paralles\\Plesk\\MySQL\\Data\\my.ini<\/pre>\n<\/div>\n<p><span style=\"color: #000000;\">In this file search for the maximum set limit under settings max_user_connections. You may either choose to increase the value OR remove the max_user_connections parameter.<\/span><\/p>\n<p><span style=\"color: #000000;\">NOTE: Removal of the max connections parameter would apply the default MySQL settings to the database.<\/span><\/p>\n<p><span style=\"color: #000000;\">That&#8217;s all to do, i hope it will help to resolve the issue.<\/span><\/p>\n<p><span style=\"color: #000000;\">You would also like to know <a href=\"https:\/\/cpanelplesk.com\/wp62\/how-to-run-backup-on-plesk-10-servers\/\">How to run backup on plesk 10+ servers<\/a>.Please Give your opinion below if you experience any issues or to discuss your ideas and experiences.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Usually this error occurs when the maximum allowed connection limit of the database has exceeded. It also means that the database already has enough number of open connections and cannot allow anymore. In that case you can either wait for someone to disconnect or if incase a specific script has opened too many connections to [&#8230;]<\/p>\n<p><a class=\"understrap-read-more-link\" href=\"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/\">Continue Reading&#8230;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5035","post","type-post","status-publish","format-standard","hentry","category-plesk-windows"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.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 - cPanel Plesk<\/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:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Plesk Backup Error : Failed to connect to database: User admin already has more than \u2018max_user_connections\u2019 active connections - cPanel Plesk\" \/>\n<meta name=\"twitter:description\" content=\"Usually this error occurs when the maximum allowed connection limit of the database has exceeded. It also means that the database already has enough number of open connections and cannot allow anymore. In that case you can either wait for someone to disconnect or if incase a specific script has opened too many connections to [...]Continue Reading...\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Seemab Saleem\" \/>\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\":\"Article\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/\"},\"author\":{\"name\":\"Seemab Saleem\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\"},\"headline\":\"Plesk Backup Error : Failed to connect to database: User admin already has more than \u2018max_user_connections\u2019 active connections\",\"datePublished\":\"2016-08-22T07:48:40+00:00\",\"dateModified\":\"2021-02-03T11:05:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/\"},\"wordCount\":191,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"articleSection\":[\"Plesk Windows\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-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 - cPanel Plesk\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\"},\"datePublished\":\"2016-08-22T07:48:40+00:00\",\"dateModified\":\"2021-02-03T11:05:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cpanelplesk.com\/wp62\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Plesk Backup Error : Failed to connect to database: User admin already has more than \u2018max_user_connections\u2019 active connections\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/\",\"name\":\"cPanel Plesk\",\"description\":\"Blog on famous hosting control panels\",\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\",\"name\":\"Farooq Omer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"width\":300,\"height\":44,\"caption\":\"Farooq Omer\"},\"logo\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\",\"name\":\"Seemab Saleem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"caption\":\"Seemab Saleem\"},\"description\":\"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!\",\"sameAs\":[\"https:\/\/cpanelplesk.com\/wp62\"],\"url\":\"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Plesk Backup Error : Failed to connect to database: User admin already has more than \u2018max_user_connections\u2019 active connections - cPanel Plesk","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/","twitter_card":"summary_large_image","twitter_title":"Plesk Backup Error : Failed to connect to database: User admin already has more than \u2018max_user_connections\u2019 active connections - cPanel Plesk","twitter_description":"Usually this error occurs when the maximum allowed connection limit of the database has exceeded. It also means that the database already has enough number of open connections and cannot allow anymore. In that case you can either wait for someone to disconnect or if incase a specific script has opened too many connections to [...]Continue Reading...","twitter_misc":{"Written by":"Seemab Saleem","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/#article","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/"},"author":{"name":"Seemab Saleem","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648"},"headline":"Plesk Backup Error : Failed to connect to database: User admin already has more than \u2018max_user_connections\u2019 active connections","datePublished":"2016-08-22T07:48:40+00:00","dateModified":"2021-02-03T11:05:21+00:00","mainEntityOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/"},"wordCount":191,"commentCount":0,"publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"articleSection":["Plesk Windows"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/","url":"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-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 - cPanel Plesk","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#website"},"datePublished":"2016-08-22T07:48:40+00:00","dateModified":"2021-02-03T11:05:21+00:00","breadcrumb":{"@id":"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cpanelplesk.com\/wp62\/plesk-backup-error-failed-connect-database-user-admin-already-max_user_connections-active-connections\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cpanelplesk.com\/wp62\/"},{"@type":"ListItem","position":2,"name":"Plesk Backup Error : Failed to connect to database: User admin already has more than \u2018max_user_connections\u2019 active connections"}]},{"@type":"WebSite","@id":"https:\/\/cpanelplesk.com\/wp62\/#website","url":"https:\/\/cpanelplesk.com\/wp62\/","name":"cPanel Plesk","description":"Blog on famous hosting control panels","publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13","name":"Farooq Omer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","width":300,"height":44,"caption":"Farooq Omer"},"logo":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/"}},{"@type":"Person","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648","name":"Seemab Saleem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","caption":"Seemab Saleem"},"description":"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!","sameAs":["https:\/\/cpanelplesk.com\/wp62"],"url":"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/"}]}},"_links":{"self":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/5035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/comments?post=5035"}],"version-history":[{"count":0,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/5035\/revisions"}],"wp:attachment":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media?parent=5035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/categories?post=5035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/tags?post=5035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}