{"id":2349,"date":"2022-05-29T02:32:57","date_gmt":"2022-05-29T02:32:57","guid":{"rendered":"https:\/\/blog.hostinger.io\/fr\/support\/2022\/05\/29\/1583511-comment-reparer-l-erreur-user-already-has-more-than-max-user-connections\/"},"modified":"2022-05-29T02:32:57","modified_gmt":"2022-05-29T02:32:57","slug":"1583511-comment-reparer-l-erreur-user-already-has-more-than-max-user-connections","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/fr\/support\/1583511-comment-reparer-l-erreur-user-already-has-more-than-max-user-connections\/","title":{"rendered":"Comment R\u00e9parer l&rsquo;Erreur : \u00ab\u00a0User Already Has More Than Max User Connections\u00a0\u00bb"},"content":{"rendered":"<p class=\"no-margin\">Si vous obtenez un &laquo;&nbsp;<b>User **** already has more than &lsquo;max_user_connections&rsquo; active connections&nbsp;&raquo;<\/b> (L&rsquo;utilisateur a d&eacute;j&agrave; plus de &lsquo;max_user_connections&rsquo; connexions actives) ou un message d&rsquo;erreur similaire, cela signifie que votre script cr&eacute;e plus de connexions &agrave; la base de donn&eacute;es que le <b>maximum autoris&eacute;<\/b> pour votre plan d&rsquo;h&eacute;bergement actuel.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Cela peut &ecirc;tre d&ucirc; &agrave; deux raisons principales :<\/p><ul>\n<li>\n<p class=\"no-margin\">Votre script cr&eacute;e des connexions <b>sans les fermer correctement<\/b> lorsqu&rsquo;elles ne sont plus n&eacute;cessaires, ou<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Votre site Web est tr&egrave;s actif et compte <b>de nombreux utilisateurs en ligne<\/b> en m&ecirc;me temps<\/p>\n<\/li>\n<\/ul><p class=\"no-margin\">Pour la premi&egrave;re option, vous pouvez <b><a href=\"\/fr\/support\/4274567-comment-reparer-l-erreur-mysql-max_connections_per_hour#h_1c9607ebd9\" target=\"_blank\" class=\"intercom-content-link\">v&eacute;rifier les connexions actives<\/a><\/b> et les terminer si elles ne sont plus n&eacute;cessaires. Pour l&rsquo;avenir, vous pouvez essayer d&rsquo;ex&eacute;cuter une commande <b>mysql_reconnect<\/b> avant chaque requ&ecirc;te.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">De plus, vous pouvez essayer d&rsquo;ajouter la commande <b>mysql_close()<\/b> &agrave; la fin de votre script pour fermer toutes les connexions ouvertes.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Et si vous avez vraiment besoin d&rsquo;autant de connexions actives &agrave; la fois, vous pouvez envisager de <b><a href=\"\/fr\/support\/1583459\" target=\"_blank\" class=\"intercom-content-link\">mettre &agrave; niveau votre plan d&rsquo;h&eacute;bergement du Web vers Cloud<\/a><\/b> &#128640;<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>REMARQUE :<\/b><\/p><ul>\n<li>\n<p class=\"no-margin\">Si vous avez besoin d&rsquo;aide suppl&eacute;mentaire pour r&eacute;soudre ce probl&egrave;me, vous pouvez envisager de contacter un d&eacute;veloppeur il y a de nombreuses options disponibles sur <b><a href=\"\/fr\/support\/5375833-services-fiverr-chez-hostinger\" target=\"_blank\" class=\"intercom-content-link\">Fiverr<\/a><\/b>.<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>R\u00e9solution de l&rsquo;erreur de connexion maximale des utilisateurs<\/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":[216],"tags":[],"class_list":["post-2349","post","type-post","status-publish","format-standard","hentry","category-correction-des-erreurs-possibles"],"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\/fr\/support\/wp-json\/wp\/v2\/posts\/2349","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/comments?post=2349"}],"version-history":[{"count":0,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/posts\/2349\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/media?parent=2349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/categories?post=2349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/tags?post=2349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}