{"id":397,"date":"2013-02-21T13:29:26","date_gmt":"2013-02-21T13:29:26","guid":{"rendered":"https:\/\/dw-qa.cleardb.net\/?p=397"},"modified":"2022-09-22T12:36:45","modified_gmt":"2022-09-22T12:36:45","slug":"common-problems-no-free-connection-to-administer-db","status":"publish","type":"post","link":"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/","title":{"rendered":"Common problems No free connection to administer db"},"content":{"rendered":"<p>Customers sometimes complain that they can&#8217;t reach their database. Now, that can happen for all kinds of reasons, starting with operator error, continuing through alien invasions of the datacenter. (The latter hasn&#8217;t happened yet &#8211; <i>at least as far as we know!<\/i>) But there&#8217;s a particular version of this issue where the customer&#8217;s application is running fine, but the user can&#8217;t reach the db from their console or admin tool.<br \/>\nThe problem is really simple, when you think about it. Each db is allowed up to a particular number of simultaneous connections, and so it&#8217;s natural to configure your application with that number in your connection pool. But if all those connections are getting used, what happens when you try to reach your db with MySQL Workbench to add a new table or perform maintenance or whatever? That&#8217;s right &#8211; you can&#8217;t. You&#8217;ll get a max_user_connections error.<br \/>\nIf you find yourself locked out of your own db in this way, you may need to edit your application&#8217;s settings to temporarily reduce the number of connections it will take. The specifics of doing that will of course depend on what your app is written in. If you need help, you can always open up a support ticket and we can point you at online resources for help. One note: if your app is written in PHP, you are probably not using persistent connections. And under those circumstances, if you&#8217;re running out of connections, it&#8217;s time to upgrade your db!<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":114,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[475],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Common problems No free connection to administer db - Navisite<\/title>\n<meta name=\"description\" content=\"Customers sometimes complain that they can&#039;t reach their database. Now, that can happen for all kinds of reasons, starting with operator error, continuing\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Common problems No free connection to administer db\" \/>\n<meta property=\"og:description\" content=\"Customers sometimes complain that they can&#039;t reach their database. Now, that can happen for all kinds of reasons, starting with operator error, continuing\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/\" \/>\n<meta property=\"og:site_name\" content=\"Navisite\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-21T13:29:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-22T12:36:45+00:00\" \/>\n<meta name=\"author\" content=\"Megan Ferringer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@navisite\" \/>\n<meta name=\"twitter:site\" content=\"@navisite\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Megan Ferringer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/\"},\"author\":{\"name\":\"Megan Ferringer\",\"@id\":\"https:\/\/www.navisite.com\/#\/schema\/person\/99bad6e33cc6d3ac27337400026e4a9f\"},\"headline\":\"Common problems No free connection to administer db\",\"datePublished\":\"2013-02-21T13:29:26+00:00\",\"dateModified\":\"2022-09-22T12:36:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/\"},\"wordCount\":270,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.navisite.com\/#organization\"},\"articleSection\":[\"News\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/\",\"url\":\"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/\",\"name\":\"Common problems No free connection to administer db - Navisite\",\"isPartOf\":{\"@id\":\"https:\/\/www.navisite.com\/#website\"},\"datePublished\":\"2013-02-21T13:29:26+00:00\",\"dateModified\":\"2022-09-22T12:36:45+00:00\",\"description\":\"Customers sometimes complain that they can't reach their database. Now, that can happen for all kinds of reasons, starting with operator error, continuing\",\"breadcrumb\":{\"@id\":\"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.navisite.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Common problems No free connection to administer db\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.navisite.com\/#website\",\"url\":\"https:\/\/www.navisite.com\/\",\"name\":\"Navisite\",\"description\":\"Elevate Your Cloud Journey\",\"publisher\":{\"@id\":\"https:\/\/www.navisite.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.navisite.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.navisite.com\/#organization\",\"name\":\"Navisite\",\"url\":\"https:\/\/www.navisite.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.navisite.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.navisite.com\/wp-content\/uploads\/2020\/02\/logo.svg\",\"contentUrl\":\"https:\/\/www.navisite.com\/wp-content\/uploads\/2020\/02\/logo.svg\",\"width\":1,\"height\":1,\"caption\":\"Navisite\"},\"image\":{\"@id\":\"https:\/\/www.navisite.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/twitter.com\/navisite\",\"https:\/\/www.instagram.com\/navisite\/\",\"https:\/\/www.linkedin.com\/company\/navisite\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.navisite.com\/#\/schema\/person\/99bad6e33cc6d3ac27337400026e4a9f\",\"name\":\"Megan Ferringer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.navisite.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.navisite.com\/wp-content\/uploads\/2021\/02\/IMG-0529-150x150.jpg\",\"contentUrl\":\"https:\/\/www.navisite.com\/wp-content\/uploads\/2021\/02\/IMG-0529-150x150.jpg\",\"caption\":\"Megan Ferringer\"},\"description\":\"Megan is the Content Marketing Manager at Navisite with more than 10 years of experience helping brands discover and tell their stories. From working at a global non-profit organization to boutique marketing agencies in Chicago, she champions the power of storytelling across all industries.\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Common problems No free connection to administer db - Navisite","description":"Customers sometimes complain that they can't reach their database. Now, that can happen for all kinds of reasons, starting with operator error, continuing","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:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/","og_locale":"en_US","og_type":"article","og_title":"Common problems No free connection to administer db","og_description":"Customers sometimes complain that they can't reach their database. Now, that can happen for all kinds of reasons, starting with operator error, continuing","og_url":"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/","og_site_name":"Navisite","article_published_time":"2013-02-21T13:29:26+00:00","article_modified_time":"2022-09-22T12:36:45+00:00","author":"Megan Ferringer","twitter_card":"summary_large_image","twitter_creator":"@navisite","twitter_site":"@navisite","twitter_misc":{"Written by":"Megan Ferringer","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/#article","isPartOf":{"@id":"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/"},"author":{"name":"Megan Ferringer","@id":"https:\/\/www.navisite.com\/#\/schema\/person\/99bad6e33cc6d3ac27337400026e4a9f"},"headline":"Common problems No free connection to administer db","datePublished":"2013-02-21T13:29:26+00:00","dateModified":"2022-09-22T12:36:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/"},"wordCount":270,"commentCount":0,"publisher":{"@id":"https:\/\/www.navisite.com\/#organization"},"articleSection":["News"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/","url":"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/","name":"Common problems No free connection to administer db - Navisite","isPartOf":{"@id":"https:\/\/www.navisite.com\/#website"},"datePublished":"2013-02-21T13:29:26+00:00","dateModified":"2022-09-22T12:36:45+00:00","description":"Customers sometimes complain that they can't reach their database. Now, that can happen for all kinds of reasons, starting with operator error, continuing","breadcrumb":{"@id":"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.navisite.com\/blog\/news\/common-problems-no-free-connection-to-administer-db\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.navisite.com\/"},{"@type":"ListItem","position":2,"name":"Common problems No free connection to administer db"}]},{"@type":"WebSite","@id":"https:\/\/www.navisite.com\/#website","url":"https:\/\/www.navisite.com\/","name":"Navisite","description":"Elevate Your Cloud Journey","publisher":{"@id":"https:\/\/www.navisite.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.navisite.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.navisite.com\/#organization","name":"Navisite","url":"https:\/\/www.navisite.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.navisite.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.navisite.com\/wp-content\/uploads\/2020\/02\/logo.svg","contentUrl":"https:\/\/www.navisite.com\/wp-content\/uploads\/2020\/02\/logo.svg","width":1,"height":1,"caption":"Navisite"},"image":{"@id":"https:\/\/www.navisite.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/twitter.com\/navisite","https:\/\/www.instagram.com\/navisite\/","https:\/\/www.linkedin.com\/company\/navisite"]},{"@type":"Person","@id":"https:\/\/www.navisite.com\/#\/schema\/person\/99bad6e33cc6d3ac27337400026e4a9f","name":"Megan Ferringer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.navisite.com\/#\/schema\/person\/image\/","url":"https:\/\/www.navisite.com\/wp-content\/uploads\/2021\/02\/IMG-0529-150x150.jpg","contentUrl":"https:\/\/www.navisite.com\/wp-content\/uploads\/2021\/02\/IMG-0529-150x150.jpg","caption":"Megan Ferringer"},"description":"Megan is the Content Marketing Manager at Navisite with more than 10 years of experience helping brands discover and tell their stories. From working at a global non-profit organization to boutique marketing agencies in Chicago, she champions the power of storytelling across all industries."}]}},"publishpress_future_action":{"enabled":false,"date":"1970-01-01 00:00:00","action":"","terms":[],"taxonomy":"","browser_timezone_offset":0},"_links":{"self":[{"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/posts\/397"}],"collection":[{"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/users\/114"}],"replies":[{"embeddable":true,"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/comments?post=397"}],"version-history":[{"count":2,"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/posts\/397\/revisions"}],"predecessor-version":[{"id":32285,"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/posts\/397\/revisions\/32285"}],"wp:attachment":[{"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/media?parent=397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/categories?post=397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.navisite.com\/wp-json\/wp\/v2\/tags?post=397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}