{"id":8739,"date":"2015-08-15T01:26:34","date_gmt":"2015-08-15T04:26:34","guid":{"rendered":"https:\/\/ivanrf.com\/en\/?p=8739"},"modified":"2015-08-31T13:19:56","modified_gmt":"2015-08-31T16:19:56","slug":"mysql-server-and-windows-10","status":"publish","type":"post","link":"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/","title":{"rendered":"MySQL Server Error on Windows 10"},"content":{"rendered":"<div class=\"wpb_row vc_row  vc_row-fluid  mk-fullwidth-false  attched-false vc_row-fluid\">\n\t<div style=\"\" class=\"vc_col-sm-12 wpb_column column_container \">\n\t\t\t\t<div style=\" margin-bottom:10px;text-align: left;\" class=\"mk-text-block  true\"><p>After upgrading to the new Windows 10, MySQL Server was not working. If you are facing the same problem, here is what I did to solve this.<\/p>\n<p>The main issue is that the <strong>Windows Service<\/strong> used for MySQL Server <strong>is removed from System Startup<\/strong>. So, if you try to use MySQL on your new Windows 10, your connection to the database will fail.<\/p>\n<p>The error message that I had was:<\/p>\n<div class=\"clearboth\"><\/div><\/div> <div class=\"vc_row wpb_row vc_inner vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-8\"><div class=\"wpb_wrapper\"><style>#blockquote-69eaa4d0c2151 {font-family: \"Oswald\"}<\/style><div style=\"font-size: 18px;\" id=\"blockquote-69eaa4d0c2151\" class=\"mk-shortcode mk-blockquote line-style \">MySQL Error Number 2003<br \/>\nCan&#8217;t connect to MySQL server on &#8216;localhost or Host IP&#8217; (10061)<\/div><\/div><\/div><div class=\"wpb_column vc_column_container vc_col-sm-4\"><div class=\"wpb_wrapper\"><div class=\"mk-image-shortcode mk-shortcode  lightbox-enabled align-left simple-frame inside-image \" style=\"max-width: 491px; margin-bottom:20px\"><div class=\"mk-image-inner\"><img class=\"lightbox-true\" alt=\"\" title=\"\" src=\"https:\/\/ivanrf.com\/wp-content\/uploads\/2015\/08\/mysql-error-01.png\" \/><div class=\"mk-image-overlay\"><\/div><a href=\"https:\/\/ivanrf.com\/wp-content\/uploads\/2015\/08\/mysql-error-01.png\" alt=\"\" data-fancybox-group=\"image-shortcode-\" title=\"\" class=\"mk-lightbox  mk-image-shortcode-lightbox\"><i class=\"mk-jupiter-icon-plus-circle\"><\/i><\/a><\/div><div class=\"clearboth\"><\/div><\/div><\/div><\/div><\/div>\t<div style=\" margin-bottom:0px;text-align: left;\" class=\"mk-text-block  true\"><p>This message is explained here: <strong><a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/can-not-connect-to-server.html\" target=\"_blank\">Can&#8217;t connect to [local] MySQL server<\/a><\/strong>, and says:<\/p>\n<div class=\"clearboth\"><\/div><\/div> <div style=\"font-size: 12px;\" id=\"blockquote-69eaa4d0c2bf7\" class=\"mk-shortcode mk-blockquote quote-style  mk-animate-element right-to-left \">The error (2003) <code class=\"code-one-line\">Can't connect to MySQL server on '<em>server<\/em>' (10061)<\/code> indicates that the network connection has been refused. You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the server.<\/p>\n<p>Start by checking whether there is a process named <a title=\"4.3.1 mysqld \u2014 The MySQL Server\" href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/mysqld.html\" target=\"_blank\"><strong>mysqld<\/strong><\/a> running on your server host. (Use <code class=\"code-one-line\">ps xa | grep mysqld<\/code> on Unix or the Task Manager on Windows.) If there is no such process, <strong>you should start the server<\/strong>.<\/p>\n<\/div>\t<div style=\" margin-bottom:10px;text-align: left;\" class=\"mk-text-block  true\"><p>In order to solve this, you need to reconfigure your server.<\/p>\n<ul>\n<li>First, open the application <em>MySQL Installer &#8211; Community<\/em> and click on <em>Reconfigure<\/em><\/li>\n<\/ul>\n<div class=\"clearboth\"><\/div><\/div> <div class=\"loop-main-wrapper\"><section id=\"gallery-loop-69eaa4d0c2de5\" data-uniqid=\"69eaa4d0c2de5\" data-style=\"gallery\" style=\"margin-bottom:20px\" class=\"mk-gallery-shortcode mk-theme-loop  \"><article class=\"gallery-one-column mk-isotop-item gallery-69eaa4d0c2de5 mk-gallery-item hover-fadebox gray_border-frame\"><div class=\"item-holder\" style=\"margin:0 8px 16px\"><div class=\"image-hover-overlay\" ><\/div><a href=\"https:\/\/ivanrf.com\/wp-content\/uploads\/2015\/08\/mysql-error-02.png\" alt=\"\" title=\"\" data-fancybox-group=\"gallery-group-69eaa4d0c2de5\" class=\"mk-lightbox  mk-image-shortcode-lightbox\"><i class=\"mk-jupiter-icon-plus-circle\"><\/i><\/a><span class=\"gallery-inner\"><img alt=\"\" title=\"\" src=\"https:\/\/ivanrf.com\/wp-content\/uploads\/bfi_thumb\/mysql-error-02-mdn0jnd6uygcv23d6r69m0fp5xsx4y767wl0ka644g.png\" \/><\/span><\/div><\/article>\n\n<div class=\"clearboth\"><\/div><\/section><div class=\"mk-pagination-holder\"><a class=\"mk-loadmore-button\" style=\"display:none;\" href=\"#\"><i class=\"mk-moon-loop-4\"><\/i><i class=\"mk-moon-arrow-down-4\"><\/i>Load More<\/a><\/div><div class=\"mk-preloader\"><\/div><\/div>\t<div style=\" margin-bottom:10px;text-align: left;\" class=\"mk-text-block  true\"><ul>\n<li>Setup <em>TCP\/IP Port Number<\/em> and <em>Firewall<\/em><\/li>\n<\/ul>\n<div class=\"clearboth\"><\/div><\/div> <div class=\"loop-main-wrapper\"><section id=\"gallery-loop-69eaa4d0c47d6\" data-uniqid=\"69eaa4d0c47d6\" data-style=\"gallery\" style=\"margin-bottom:20px\" class=\"mk-gallery-shortcode mk-theme-loop  \"><article class=\"gallery-two-column mk-isotop-item gallery-69eaa4d0c47d6 mk-gallery-item hover-fadebox gray_border-frame\"><div class=\"item-holder\" style=\"margin:0 8px 16px\"><div class=\"image-hover-overlay\" ><\/div><a href=\"https:\/\/ivanrf.com\/wp-content\/uploads\/2015\/08\/mysql-error-03.png\" alt=\"\" title=\"\" data-fancybox-group=\"gallery-group-69eaa4d0c47d6\" class=\"mk-lightbox  mk-image-shortcode-lightbox\"><i class=\"mk-jupiter-icon-plus-circle\"><\/i><\/a><span class=\"gallery-inner\"><img alt=\"\" title=\"\" src=\"https:\/\/ivanrf.com\/wp-content\/uploads\/bfi_thumb\/mysql-error-03-mdn0jr4cq2ptospaj1lx69unsajb29ft1tc141tfsg.png\" \/><\/span><\/div><\/article>\n\n<article class=\"gallery-two-column mk-isotop-item gallery-69eaa4d0c47d6 mk-gallery-item hover-fadebox gray_border-frame\"><div class=\"item-holder\" style=\"margin:0 8px 16px\"><div class=\"image-hover-overlay\" ><\/div><a href=\"https:\/\/ivanrf.com\/wp-content\/uploads\/2015\/08\/mysql-error-04.png\" alt=\"\" title=\"\" data-fancybox-group=\"gallery-group-69eaa4d0c47d6\" class=\"mk-lightbox  mk-image-shortcode-lightbox\"><i class=\"mk-jupiter-icon-plus-circle\"><\/i><\/a><span class=\"gallery-inner\"><img alt=\"\" title=\"\" src=\"https:\/\/ivanrf.com\/wp-content\/uploads\/bfi_thumb\/mysql-error-04-mdn0juvpheuyz8jtx38fg8wi5u0rx1uqebxz15nv3k.png\" \/><\/span><\/div><\/article>\n\n<div class=\"clearboth\"><\/div><\/section><div class=\"mk-pagination-holder\"><a class=\"mk-loadmore-button\" style=\"display:none;\" href=\"#\"><i class=\"mk-moon-loop-4\"><\/i><i class=\"mk-moon-arrow-down-4\"><\/i>Load More<\/a><\/div><div class=\"mk-preloader\"><\/div><\/div>\t<div style=\" margin-bottom:10px;text-align: left;\" class=\"mk-text-block  true\"><ul>\n<li><strong>Check<\/strong> <em>Configure MySQL Server as a Windows Service<\/em> and also <strong>check<\/strong> <em>Start the MySQL Server at System Startup<\/em><\/li>\n<\/ul>\n<div class=\"clearboth\"><\/div><\/div> <div class=\"loop-main-wrapper\"><section id=\"gallery-loop-69eaa4d0c5d64\" data-uniqid=\"69eaa4d0c5d64\" data-style=\"gallery\" style=\"margin-bottom:20px\" class=\"mk-gallery-shortcode mk-theme-loop  \"><article class=\"gallery-one-column mk-isotop-item gallery-69eaa4d0c5d64 mk-gallery-item hover-fadebox gray_border-frame\"><div class=\"item-holder\" style=\"margin:0 8px 16px\"><div class=\"image-hover-overlay\" ><\/div><a href=\"https:\/\/ivanrf.com\/wp-content\/uploads\/2015\/08\/mysql-error-05.png\" alt=\"\" title=\"\" data-fancybox-group=\"gallery-group-69eaa4d0c5d64\" class=\"mk-lightbox  mk-image-shortcode-lightbox\"><i class=\"mk-jupiter-icon-plus-circle\"><\/i><\/a><span class=\"gallery-inner\"><img alt=\"\" title=\"\" src=\"https:\/\/ivanrf.com\/wp-content\/uploads\/bfi_thumb\/mysql-error-05-mdn0jyn94yvsqdmzcw1sfxl8ak9bpbfy9geublpe1s.png\" \/><\/span><\/div><\/article>\n\n<div class=\"clearboth\"><\/div><\/section><div class=\"mk-pagination-holder\"><a class=\"mk-loadmore-button\" style=\"display:none;\" href=\"#\"><i class=\"mk-moon-loop-4\"><\/i><i class=\"mk-moon-arrow-down-4\"><\/i>Load More<\/a><\/div><div class=\"mk-preloader\"><\/div><\/div>\t<div style=\" margin-bottom:10px;text-align: left;\" class=\"mk-text-block  true\"><ul>\n<li>Apply the server configuration and your done!<\/li>\n<\/ul>\n<div class=\"clearboth\"><\/div><\/div> <div class=\"loop-main-wrapper\"><section id=\"gallery-loop-69eaa4d0c7357\" data-uniqid=\"69eaa4d0c7357\" data-style=\"gallery\" style=\"margin-bottom:20px\" class=\"mk-gallery-shortcode mk-theme-loop  \"><article class=\"gallery-one-column mk-isotop-item gallery-69eaa4d0c7357 mk-gallery-item hover-fadebox gray_border-frame\"><div class=\"item-holder\" style=\"margin:0 8px 16px\"><div class=\"image-hover-overlay\" ><\/div><a href=\"https:\/\/ivanrf.com\/wp-content\/uploads\/2015\/08\/mysql-error-06.png\" alt=\"\" title=\"\" data-fancybox-group=\"gallery-group-69eaa4d0c7357\" class=\"mk-lightbox  mk-image-shortcode-lightbox\"><i class=\"mk-jupiter-icon-plus-circle\"><\/i><\/a><span class=\"gallery-inner\"><img alt=\"\" title=\"\" src=\"https:\/\/ivanrf.com\/wp-content\/uploads\/bfi_thumb\/mysql-error-06-mdn0k2elwb0y0thiqxoapwn2o3qsk3uvlz0s8pjtcw.png\" \/><\/span><\/div><\/article>\n\n<div class=\"clearboth\"><\/div><\/section><div class=\"mk-pagination-holder\"><a class=\"mk-loadmore-button\" style=\"display:none;\" href=\"#\"><i class=\"mk-moon-loop-4\"><\/i><i class=\"mk-moon-arrow-down-4\"><\/i>Load More<\/a><\/div><div class=\"mk-preloader\"><\/div><\/div><div class=\"mk-content-box mk-shortcode  \"><span class=\"content-box-heading\"><i class=\"mk-moon-warning-2\"><\/i> Wamp Server \/ Apache not working<\/span><div class=\"content-box-content\">\t<div style=\" margin-bottom:0px;text-align: left;\" class=\"mk-text-block  true\"><p>In my case, WampServer worked fine after upgrading to Windows 10. However, I found that some users had issues with the Apache service (<a href=\"http:\/\/forum.wampserver.com\/read.php?2,134603\" target=\"_blank\">see forum<\/a>).<\/p>\n<p>In that particular case, the solution was:<\/p>\n<ul>\n<li>Left click WampServer icon -&gt; Apache -&gt; Service -&gt; Install Service<\/li>\n<li>Left click WampServer icon -&gt; Apache -&gt; Service -&gt; Start\/Resume Service<\/li>\n<\/ul>\n<div class=\"clearboth\"><\/div><\/div> \n<\/div><div class=\"clearboth\"><\/div><\/div>\n\t<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Describes how to troubleshoot problems that occur with MySQL Server after upgrading to Windows 10.<\/p>\n","protected":false},"author":1,"featured_media":8740,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[146,113],"tags":[147,148,116,141],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL Server Error on Windows 10 - Ivan Ridao Freitas<\/title>\n<meta name=\"description\" content=\"Describes how to troubleshoot problems that occur with MySQL Server after upgrading to Windows 10. MySQL Error 2003: Can\u2019t connect to MySQL server (10061).\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Server Error on Windows 10 - Ivan Ridao Freitas\" \/>\n<meta property=\"og:description\" content=\"Describes how to troubleshoot problems that occur with MySQL Server after upgrading to Windows 10. MySQL Error 2003: Can\u2019t connect to MySQL server (10061).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/\" \/>\n<meta property=\"og:site_name\" content=\"Ivan Ridao Freitas\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ivanrfcom\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ivanrfcom\/\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-15T04:26:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-08-31T16:19:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ivanrf.com\/wp-content\/uploads\/2015\/08\/mysql-error-cover.png\" \/>\n\t<meta property=\"og:image:width\" content=\"792\" \/>\n\t<meta property=\"og:image:height\" content=\"350\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ivanrfcom\" \/>\n<meta name=\"twitter:site\" content=\"@ivanrfcom\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"Ivan Ridao Freitas\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"3 minutes\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ivanrf.com\/#website\",\"url\":\"https:\/\/ivanrf.com\/\",\"name\":\"Ivan Ridao Freitas\",\"description\":false,\"publisher\":{\"@id\":\"https:\/\/ivanrf.com\/#\/schema\/person\/c12196a2c840d68d3ebc302415037a6c\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ivanrf.com\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/ivanrf.com\/wp-content\/uploads\/2015\/08\/mysql-error-cover.png\",\"width\":792,\"height\":350},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/#webpage\",\"url\":\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/\",\"name\":\"MySQL Server Error on Windows 10 - Ivan Ridao Freitas\",\"isPartOf\":{\"@id\":\"https:\/\/ivanrf.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/#primaryimage\"},\"datePublished\":\"2015-08-15T04:26:34+00:00\",\"dateModified\":\"2015-08-31T16:19:56+00:00\",\"description\":\"Describes how to troubleshoot problems that occur with MySQL Server after upgrading to Windows 10. MySQL Error 2003: Can\\u2019t connect to MySQL server (10061).\",\"breadcrumb\":{\"@id\":\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ivanrf.com\/en\/home\/\",\"url\":\"https:\/\/ivanrf.com\/en\/home\/\",\"name\":\"Inicio\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ivanrf.com\/en\/category\/mysql\/\",\"url\":\"https:\/\/ivanrf.com\/en\/category\/mysql\/\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"position\":3,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/\",\"url\":\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/\",\"name\":\"MySQL Server Error on Windows 10\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/#webpage\"},\"author\":{\"@id\":\"https:\/\/ivanrf.com\/#\/schema\/person\/c12196a2c840d68d3ebc302415037a6c\"},\"headline\":\"MySQL Server Error on Windows 10\",\"datePublished\":\"2015-08-15T04:26:34+00:00\",\"dateModified\":\"2015-08-31T16:19:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/#webpage\"},\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/ivanrf.com\/#\/schema\/person\/c12196a2c840d68d3ebc302415037a6c\"},\"image\":{\"@id\":\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/#primaryimage\"},\"keywords\":\"MySQL,MySQL Server,Windows,Windows 10\",\"articleSection\":\"MySQL,Windows\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/ivanrf.com\/en\/mysql-server-and-windows-10\/#respond\"]}]},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/ivanrf.com\/#\/schema\/person\/c12196a2c840d68d3ebc302415037a6c\",\"name\":\"Ivan Ridao Freitas\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ivanrf.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4daad3ef38b29f5c066dcb31ff3c110?s=96&d=mm&r=g\",\"caption\":\"Ivan Ridao Freitas\"},\"logo\":{\"@id\":\"https:\/\/ivanrf.com\/#personlogo\"},\"description\":\"Systems Engineer. Software, website and mobile app developer for businesses and individuals.\",\"sameAs\":[\"https:\/\/ivanrf.com\",\"https:\/\/www.facebook.com\/ivanrfcom\/\",\"https:\/\/twitter.com\/ivanrfcom\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/ivanrf.com\/en\/wp-json\/wp\/v2\/posts\/8739"}],"collection":[{"href":"https:\/\/ivanrf.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ivanrf.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ivanrf.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ivanrf.com\/en\/wp-json\/wp\/v2\/comments?post=8739"}],"version-history":[{"count":0,"href":"https:\/\/ivanrf.com\/en\/wp-json\/wp\/v2\/posts\/8739\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ivanrf.com\/en\/wp-json\/wp\/v2\/media\/8740"}],"wp:attachment":[{"href":"https:\/\/ivanrf.com\/en\/wp-json\/wp\/v2\/media?parent=8739"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ivanrf.com\/en\/wp-json\/wp\/v2\/categories?post=8739"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ivanrf.com\/en\/wp-json\/wp\/v2\/tags?post=8739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}