{"id":1955,"date":"2022-03-29T22:50:42","date_gmt":"2022-03-30T02:50:42","guid":{"rendered":"http:\/\/www.insidethe.com\/blog\/?p=1955"},"modified":"2022-03-29T22:50:42","modified_gmt":"2022-03-30T02:50:42","slug":"mysql-5-7-service-fails-to-start-after-configuration-change","status":"publish","type":"post","link":"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/","title":{"rendered":"MySQL 5.7 Service Fails To Start After Configuration Change"},"content":{"rendered":"<p>After changing the MySQL 5.7 my.ini file the MySQL Windows Service hangs while starting up. Killed the mysqld.exe process with Task Manager and launched it in debug mode to see the following error message:<\/p>\n<pre>C:\\&gt;\"C:\\Program Files\\MySQL\\MySQL Server 5.7\\bin\\mysqld.exe\" --defaults-file=\"C:\\ProgramData\\MySQL\\MySQL Server 5.7\\my.ini\" --verbose\r\nmysqld: [ERROR] Found option without preceding group in config file C:\\ProgramData\\MySQL\\MySQL Server 5.7\\my.ini at line 1!\r\nmysqld: [ERROR] Fatal error in defaults handling. Program aborted!<\/pre>\n<p>The configuration change was made with notepad.exe on Server 2016 and even after removing the configuration change, MySQL would not launch.<\/p>\n<p>I used Notepad++ to change the file encoding from UTF-8-BOM to UTF-8 and tried to launch MySQL again. Success!<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After changing the MySQL 5.7 my.ini file the MySQL Windows Service hangs while starting up. Killed the mysqld.exe process with Task Manager and launched it in debug mode to see the following error message: C:\\&gt;&#8221;C:\\Program Files\\MySQL\\MySQL Server 5.7\\bin\\mysqld.exe&#8221; &#8211;defaults-file=&#8221;C:\\ProgramData\\MySQL\\MySQL Server 5.7\\my.ini&#8221; &#8211;verbose mysqld: [ERROR] Found option without preceding group in config file C:\\ProgramData\\MySQL\\MySQL Server 5.7\\my.ini [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[17],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL 5.7 Service Fails To Start After Configuration Change - Insidethe.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL 5.7 Service Fails To Start After Configuration Change - Insidethe.com\" \/>\n<meta property=\"og:description\" content=\"After changing the MySQL 5.7 my.ini file the MySQL Windows Service hangs while starting up. Killed the mysqld.exe process with Task Manager and launched it in debug mode to see the following error message: C:&gt;&quot;C:Program FilesMySQLMySQL Server 5.7binmysqld.exe&quot; --defaults-file=&quot;C:ProgramDataMySQLMySQL Server 5.7my.ini&quot; --verbose mysqld: [ERROR] Found option without preceding group in config file C:ProgramDataMySQLMySQL Server 5.7my.ini [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/\" \/>\n<meta property=\"og:site_name\" content=\"Insidethe.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-30T02:50:42+00:00\" \/>\n<meta name=\"author\" content=\"Jared\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jared\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/\",\"url\":\"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/\",\"name\":\"MySQL 5.7 Service Fails To Start After Configuration Change - Insidethe.com\",\"isPartOf\":{\"@id\":\"https:\/\/insidethe.com\/blog\/#website\"},\"datePublished\":\"2022-03-30T02:50:42+00:00\",\"dateModified\":\"2022-03-30T02:50:42+00:00\",\"author\":{\"@id\":\"https:\/\/insidethe.com\/blog\/#\/schema\/person\/046e8441af869a735c4e31ac51541a99\"},\"breadcrumb\":{\"@id\":\"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/insidethe.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL 5.7 Service Fails To Start After Configuration Change\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/insidethe.com\/blog\/#website\",\"url\":\"https:\/\/insidethe.com\/blog\/\",\"name\":\"Insidethe.com\",\"description\":\"It is my space, but better than myspace\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/insidethe.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/insidethe.com\/blog\/#\/schema\/person\/046e8441af869a735c4e31ac51541a99\",\"name\":\"Jared\",\"sameAs\":[\"https:\/\/www.insidethe.com\/blog\"],\"url\":\"https:\/\/insidethe.com\/blog\/author\/jared\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL 5.7 Service Fails To Start After Configuration Change - Insidethe.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/","og_locale":"en_US","og_type":"article","og_title":"MySQL 5.7 Service Fails To Start After Configuration Change - Insidethe.com","og_description":"After changing the MySQL 5.7 my.ini file the MySQL Windows Service hangs while starting up. Killed the mysqld.exe process with Task Manager and launched it in debug mode to see the following error message: C:&gt;\"C:Program FilesMySQLMySQL Server 5.7binmysqld.exe\" --defaults-file=\"C:ProgramDataMySQLMySQL Server 5.7my.ini\" --verbose mysqld: [ERROR] Found option without preceding group in config file C:ProgramDataMySQLMySQL Server 5.7my.ini [&hellip;]","og_url":"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/","og_site_name":"Insidethe.com","article_published_time":"2022-03-30T02:50:42+00:00","author":"Jared","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jared","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/","url":"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/","name":"MySQL 5.7 Service Fails To Start After Configuration Change - Insidethe.com","isPartOf":{"@id":"https:\/\/insidethe.com\/blog\/#website"},"datePublished":"2022-03-30T02:50:42+00:00","dateModified":"2022-03-30T02:50:42+00:00","author":{"@id":"https:\/\/insidethe.com\/blog\/#\/schema\/person\/046e8441af869a735c4e31ac51541a99"},"breadcrumb":{"@id":"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/insidethe.com\/blog\/2022\/03\/mysql-5-7-service-fails-to-start-after-configuration-change\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/insidethe.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL 5.7 Service Fails To Start After Configuration Change"}]},{"@type":"WebSite","@id":"https:\/\/insidethe.com\/blog\/#website","url":"https:\/\/insidethe.com\/blog\/","name":"Insidethe.com","description":"It is my space, but better than myspace","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/insidethe.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/insidethe.com\/blog\/#\/schema\/person\/046e8441af869a735c4e31ac51541a99","name":"Jared","sameAs":["https:\/\/www.insidethe.com\/blog"],"url":"https:\/\/insidethe.com\/blog\/author\/jared\/"}]}},"_links":{"self":[{"href":"https:\/\/insidethe.com\/blog\/wp-json\/wp\/v2\/posts\/1955"}],"collection":[{"href":"https:\/\/insidethe.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/insidethe.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/insidethe.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/insidethe.com\/blog\/wp-json\/wp\/v2\/comments?post=1955"}],"version-history":[{"count":1,"href":"https:\/\/insidethe.com\/blog\/wp-json\/wp\/v2\/posts\/1955\/revisions"}],"predecessor-version":[{"id":1956,"href":"https:\/\/insidethe.com\/blog\/wp-json\/wp\/v2\/posts\/1955\/revisions\/1956"}],"wp:attachment":[{"href":"https:\/\/insidethe.com\/blog\/wp-json\/wp\/v2\/media?parent=1955"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/insidethe.com\/blog\/wp-json\/wp\/v2\/categories?post=1955"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/insidethe.com\/blog\/wp-json\/wp\/v2\/tags?post=1955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}