{"id":1438,"date":"2019-02-08T10:36:01","date_gmt":"2019-02-08T10:36:01","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2019\/02\/08\/1583511-how-to-fix-the-user-already-has-more-than-max-user-connections-error-at-hostinger\/"},"modified":"2019-02-08T10:36:01","modified_gmt":"2019-02-08T10:36:01","slug":"1583511-how-to-fix-the-user-already-has-more-than-max-user-connections-error-at-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/1583511-how-to-fix-the-user-already-has-more-than-max-user-connections-error-at-hostinger\/","title":{"rendered":"How to Fix the &#8216;User Already Has More Than Max User Connections&#8217; Error at Hostinger"},"content":{"rendered":"<p class=\"no-margin\">If you get a &ldquo;<b>User already has more than &lsquo;max_user_connections&rsquo; active connections<\/b>&ldquo; error message or similar, it means that your script is creating more user connections to the database than your hosting plan allows.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">There are two main reasons behind this error:<\/p><ul>\n<li>\n<p class=\"no-margin\">Your script creates connections <b>without properly closing them<\/b> when they are no longer needed, or<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Your website is very active and has <b>many users online<\/b> at the same time<\/p>\n<\/li>\n<\/ul><p class=\"no-margin\">In regards to the first reason, you may want to <b><a href=\"\/support\/4274567-how-to-fix-max_connections_per_hour-mysql-error#h_7f0f5900a0\" target=\"_blank\" class=\"intercom-content-link\">check for any active connections<\/a><\/b> and terminate the ones that are no longer necessary. For the future, you can try executing a <b>mysql_reconnect<\/b> command before each query. Additionally, you may try adding the command <b>mysql_close()<\/b> at the end of your script to close all open connections.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">If you definitely require many active connections at once, consider <b><a href=\"\/support\/1583459-how-to-upgrade-your-hosting-plan\" target=\"_blank\" class=\"intercom-content-link\">upgrading your hosting plan<\/a><\/b> &#128640; <\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>NOTE<\/b><\/p><ul>\n<li>\n<p class=\"no-margin\">If you need further help with this issue, we suggest you collaborate with a dedicated developer &#8210; there are plenty of specialists available on <b><a href=\"\/support\/5375833-fiverr-services-at-hostinger\" target=\"_blank\" class=\"intercom-content-link\">Fiverr<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>What to do if you reach the user connection limit<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[241],"tags":[],"class_list":["post-1438","post","type-post","status-publish","format-standard","hentry","category-database-troubleshooting"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/1583511-how-to-fix-the-user-already-has-more-than-max-user-connections-error-at-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/1583511-como-solucionar-el-error-max_user_connections-en-hostinger\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/1583511-comment-reparer-l-erreur-user-already-has-more-than-max-user-connections\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/1583511-bagaimana-cara-mengatasi-error-user-already-has-more-than-max-user-connections-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/1583511-como-corrigir-o-erro-user-already-has-more-than-max-user-connections-no-hostinger\/","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/1583511----user-already-has-more-than-max-user-connections\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1438","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/comments?post=1438"}],"version-history":[{"count":0,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1438\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1438"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1438"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1438"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}