{"id":4250,"date":"2019-03-20T07:06:57","date_gmt":"2019-03-20T06:06:57","guid":{"rendered":"https:\/\/assistance.groupemagiconline.com\/?post_type=ht_kb&#038;p=4250"},"modified":"2022-10-10T09:41:57","modified_gmt":"2022-10-10T07:41:57","slug":"erreur-mysql","status":"publish","type":"ht_kb","link":"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/erreur-mysql\/","title":{"rendered":"MySQL error"},"content":{"rendered":"<p style=\"text-align: justify;\">Here is a list of the most common error messages concerning your database:<\/p>\n<h3 style=\"text-align: justify;\"><span id=\".22Access_denied_for_user_....40....22\" class=\"mw-headline\">Access denied for user <em>user@domain<\/em><\/span><\/h3>\n<p style=\"text-align: justify;\">This means that you are using an incorrect login and\/or password and\/or an incorrect database server address.<br \/>\nSolution: Check your database connection settings from your customer area.<\/p>\n<h3 style=\"text-align: justify;\"><span id=\".22Can.27t_connect_to_local_MySQL_server_through_socket....22\" class=\"mw-headline\">Can't connect to local MySQL server through socket<\/span><\/h3>\n<p style=\"text-align: justify;\">This means that you did not set the database server address correctly in your connection script. Solution: Check your database connection settings from your customer area.<\/p>\n<h3 style=\"text-align: justify;\"><span class=\"mw-headline\">User\u00a0<\/span><em><span id=\".22Access_denied_for_user_....40....22\" class=\"mw-headline\">user<\/span><\/em><span id=\".22User_..._reached_max_user_connection_limit.22\" class=\"mw-headline\"><em>\u00a0<\/em>reached max_user_connection limit<\/span><\/h3>\n<p style=\"text-align: justify;\">This error is due to the fact that you have reached the maximum allowed number of simultaneous connections to your database.<br \/>\nIf you have a lot of traffic, it is better to open the SQL connection only when you are going to use it and then close it (with mysql_close()) once you no longer need to interact with the database.<br \/>\nAlso, persistent connections (made with mysql_pconnect()) should be avoided.<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">    \t\t<div class=\"hts-messages hts-messages--info\"   >\r\n    \t\t\t    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tIT IS NOT POSSIBLE TO CUSTOMIZE THE NAME OF YOUR DATABASE EXCEPT FOR SHARED OFFERS WITH THE DEDICATED SQL OPTION    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t    \t\t<div class=\"hts-messages hts-messages--info\"   >\r\n    \t\t\t    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tIT IS NOT POSSIBLE TO CHANGE THE NAME OF A DATABASE EITHER, EVEN FOR SHARED OFFERS WITH THE DEDICATED SQL OPTION    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t<\/span><\/p>\n<table class=\"wikitable\">\n<caption><span style=\"color: #33cccc;\"><em>Limit of simultaneous connections to a database<\/em><\/span><\/caption>\n<tbody>\n<tr>\n<td><span style=\"color: #33cccc;\"><em>MUTU START<\/em><\/span><\/td>\n<td><span style=\"color: #33cccc;\"><em>4 simultaneous connections<\/em><\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"color: #33cccc;\"><em>MUTU BOOST<\/em><\/span><\/td>\n<td><span style=\"color: #33cccc;\"><em>10 simultaneous connections<\/em><\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"color: #33cccc;\"><em>MUTU MAX<\/em><\/span><\/td>\n<td><span style=\"color: #33cccc;\"><em>20 simultaneous connections<\/em><\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"color: #33cccc;\"><em>PERFORMANCE<\/em><\/span><\/td>\n<td><span style=\"color: #33cccc;\"><em>You can set the limit of your choice, although it is recommended not to exceed 100 simultaneous connections because you are limited by the resources of this offer<\/em><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>","protected":false},"excerpt":{"rendered":"<p>Here is a list of the most common error messages concerning your database: Access denied for user user@domain This means that you are using an incorrect login and\/or password and\/or an incorrect database server address. Solution: Check the connection parameters to...<\/p>","protected":false},"author":52,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[734,1246,733,727],"ht-kb-tag":[671],"class_list":["post-4250","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-mutualise-standard","ht_kb_category-hebergements-cloud-evolution","ht_kb_category-performance","ht_kb_category-mysql-prive","ht_kb_tag-mysql"],"_links":{"self":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/4250","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/users\/52"}],"replies":[{"embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/comments?post=4250"}],"version-history":[{"count":1,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/4250\/revisions"}],"predecessor-version":[{"id":11231,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/4250\/revisions\/11231"}],"wp:attachment":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/media?parent=4250"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-category?post=4250"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=4250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}