{"id":107,"date":"2020-08-31T16:40:01","date_gmt":"2020-08-31T08:40:01","guid":{"rendered":"https:\/\/www.tunerli.com\/?p=107"},"modified":"2020-08-31T16:40:01","modified_gmt":"2020-08-31T08:40:01","slug":"mysql-failed-to-get-started","status":"publish","type":"post","link":"https:\/\/www.tunerli.com\/index.php\/2020\/08\/31\/mysql-failed-to-get-started\/","title":{"rendered":"MySQL Failed to Get Started"},"content":{"rendered":"\n<p>haven&#8217;t accessed my website during the last weekend, and wanted to give it a random check just now but noticed it&#8217;s down, with the error message like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"473\" height=\"1024\" src=\"https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG53-1-473x1024.jpeg\" alt=\"\" class=\"wp-image-109\" srcset=\"https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG53-1-473x1024.jpeg 473w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG53-1-138x300.jpeg 138w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG53-1-768x1664.jpeg 768w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG53-1-709x1536.jpeg 709w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG53-1-945x2048.jpeg 945w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG53-1.jpeg 1080w\" sizes=\"auto, (max-width: 473px) 100vw, 473px\" \/><\/figure>\n\n\n\n<p>as MySQL is the database for my website, so remote to the host and check MySQL status, and notice it&#8217;s down (for more than one day&#8230;Oops, would be sorry for my users if .they were using my website for blogs, etc.)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"283\" src=\"https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162247@2x-1024x283.png\" alt=\"\" class=\"wp-image-110\" srcset=\"https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162247@2x-1024x283.png 1024w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162247@2x-300x83.png 300w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162247@2x-768x213.png 768w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162247@2x-1536x425.png 1536w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162247@2x-2048x567.png 2048w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162247@2x-1600x443.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>run the command: sudo <strong><em>systemctl start mysql.service<\/em><\/strong>, and then it&#8217;s back to active<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"734\" height=\"52\" src=\"https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162313@2x.png\" alt=\"\" class=\"wp-image-111\" srcset=\"https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162313@2x.png 734w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162313@2x-300x21.png 300w\" sizes=\"auto, (max-width: 734px) 100vw, 734px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"236\" src=\"https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162413@2x-1024x236.png\" alt=\"\" class=\"wp-image-112\" srcset=\"https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162413@2x-1024x236.png 1024w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162413@2x-300x69.png 300w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162413@2x-768x177.png 768w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162413@2x-1536x354.png 1536w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162413@2x-2048x471.png 2048w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WX20200831-162413@2x-1600x368.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>give it a refresh, and now my website is back to normal<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"473\" height=\"1024\" src=\"https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG54-473x1024.jpeg\" alt=\"\" class=\"wp-image-113\" srcset=\"https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG54-473x1024.jpeg 473w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG54-138x300.jpeg 138w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG54-768x1664.jpeg 768w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG54-709x1536.jpeg 709w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG54-945x2048.jpeg 945w, https:\/\/www.tunerli.com\/wp-content\/uploads\/2020\/08\/WechatIMG54.jpeg 1080w\" sizes=\"auto, (max-width: 473px) 100vw, 473px\" \/><\/figure>\n\n\n\n<p>there might be multiple reasons why MySQL fails to get started, especially when we can not start it again. but as a simple start gets it back to normal, I will just let it go. maybe will dig deeper if any other issues happen or this same issue comes back again.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>haven&#8217;t accessed my website during the last weekend, and wanted to give it a random check just now but noticed it&#8217;s down, with the error message like this: as MySQL<a href=\"https:\/\/www.tunerli.com\/index.php\/2020\/08\/31\/mysql-failed-to-get-started\/\" class=\"more-link\"><span class=\"more-button\">Continue reading<span class=\"screen-reader-text\">MySQL Failed to Get Started<\/span><\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-107","post","type-post","status-publish","format-standard","hentry","category-technical-issues-and-resolutions"],"_links":{"self":[{"href":"https:\/\/www.tunerli.com\/index.php\/wp-json\/wp\/v2\/posts\/107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tunerli.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tunerli.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tunerli.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tunerli.com\/index.php\/wp-json\/wp\/v2\/comments?post=107"}],"version-history":[{"count":1,"href":"https:\/\/www.tunerli.com\/index.php\/wp-json\/wp\/v2\/posts\/107\/revisions"}],"predecessor-version":[{"id":114,"href":"https:\/\/www.tunerli.com\/index.php\/wp-json\/wp\/v2\/posts\/107\/revisions\/114"}],"wp:attachment":[{"href":"https:\/\/www.tunerli.com\/index.php\/wp-json\/wp\/v2\/media?parent=107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tunerli.com\/index.php\/wp-json\/wp\/v2\/categories?post=107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tunerli.com\/index.php\/wp-json\/wp\/v2\/tags?post=107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}