{"id":2642,"date":"2019-10-01T21:42:25","date_gmt":"2019-10-01T20:42:25","guid":{"rendered":"http:\/\/www.dpscomputing.com\/blog\/?p=2642"},"modified":"2021-03-01T21:36:41","modified_gmt":"2021-03-01T21:36:41","slug":"mysqli_connect-hy000-2002-no-connection-could-be-made-because-the-target-machine-actively-refused-it","status":"publish","type":"post","link":"https:\/\/www.dpscomputing.com\/blog\/2019\/10\/01\/mysqli_connect-hy000-2002-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/","title":{"rendered":"mysqli_connect(): (HY000\/2002): No connection could be made because the target machine actively refused it"},"content":{"rendered":"\n

So you’ve come to do a bit of development and you fire up XAMMP or AMPPS only to find… boom! You’re hit with an error. <\/p>\n\n\n\n

Is it a dev error? Did I leave something broke last time? These are all possibilities – however, when you see this error:<\/p>\n\n\n\n

mysqli_connect(): (HY000\/2002): No connection could be made because the target machine actively refused it<\/code><\/pre>\n\n\n\n
The likely cause is usually quite simple to fix and a quick configuration change (and back) should help you recover.  <\/p>\n\n\n\n
How To Fix<\/h2>\n\n\n\n
We’ll walk through the process in AMPPS, the steps are similar in other clients.  <\/p>\n\n\n\n
If you haven’t already, start the AMPPS application server.  <\/p>\n\n\n\n
Then open the main AMPPS window (if it’s not already on screen, double click the colourful AMPPS icon in your toolbar):<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Click the ‘cog’ icon next to MySQL:<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Then click the settings icon (the spanner and screwdriver):<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
This should open the my.ini file for your local SQL server.  From here, navigate to the ‘Server Section’ and search for the innodb_force_recovery option:<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
This is and should usually be 0.  Set this to one.  Save the configuration file and head back to the AMPPS control panel.  From there, you should notice a message saying your configuration has been successfully updated:<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Now we need to restart the MySQL server by clicking the restart button.  CAUTION!  The restart button and the reset button icons are easily mixed up – hover over the icon if your unsure to display the tooltip to ensure you get the right one!<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Once you’ve pressed this, you should see a message that the server has been successfully restarted:<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Now if you try to visit your web page hosted on localhost it should now load correctly.  <\/p>\n\n\n\n
We shouldn’t leave recovery mode on after things are back up and running  – some things won’t work correctly or behave strangely.  Head back to the configuration file, set the value of innodb_force_recovery back to 0 and restart the MySQL server again.  <\/p>\n\n\n\n
Hey presto – your localhost development server is back up and running!<\/p>\n","protected":false},"excerpt":{"rendered":"
So you’ve come to do a bit of development and you fire up XAMMP or AMPPS only to find… boom! You’re hit with an error. Is it a dev error? Did I leave something...<\/p>\n","protected":false},"author":1,"featured_media":2644,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"mysqli_connect(): (HY000\/2002): No connection could be made because the target machine actively refused it #development #websites #MySQLError #localhost","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[29],"tags":[2458,2454,2455,2460,2453,2456,2457,2459],"class_list":["post-2642","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-hy000-2002","tag-localhost-mysql","tag-localhost-mysql-error","tag-localhost-website-wont-connect","tag-mysql-error","tag-mysqli_connect-error","tag-mysqli_connect","tag-no-connection-could-be-made-because-the-target-machine-actively-refused-it"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.dpscomputing.com\/blog\/wp-content\/uploads\/2019\/10\/image-6.png","jetpack_shortlink":"https:\/\/wp.me\/p3nsfA-GC","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/posts\/2642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/comments?post=2642"}],"version-history":[{"count":2,"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/posts\/2642\/revisions"}],"predecessor-version":[{"id":3034,"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/posts\/2642\/revisions\/3034"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/media\/2644"}],"wp:attachment":[{"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/media?parent=2642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/categories?post=2642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/tags?post=2642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}