{"id":19048,"date":"2020-10-22T08:27:18","date_gmt":"2020-10-22T08:27:18","guid":{"rendered":"http:\/\/www.devopsschool.com\/blog\/?p=19048"},"modified":"2020-12-09T12:19:26","modified_gmt":"2020-12-09T12:19:26","slug":"how-to-fix-mysql-shutdown-unexpectedly-error","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-fix-mysql-shutdown-unexpectedly-error\/","title":{"rendered":"How to fix MySQL Shutdown Unexpectedly Error"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">Errors : mysql_error.log<\/h4>\n\n\n\n<p>2020-10-22 12:48:24 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions<br>2020-10-22 12:48:24 0 [Note] InnoDB: Uses event mutexes<br>2020-10-22 12:48:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11<br>2020-10-22 12:48:24 0 [Note] InnoDB: Number of pools: 1<br>2020-10-22 12:48:24 0 [Note] InnoDB: Using SSE2 crc32 instructions<br>2020-10-22 12:48:24 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M<br>2020-10-22 12:48:24 0 [Note] InnoDB: Completed initialization of buffer pool<br>2020-10-22 12:48:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=249429322<br>2020-10-22 12:48:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.<br>2020-10-22 12:48:26 0 [Note] InnoDB: Removed temporary tablespace data file: &#8220;ibtmp1&#8221;<br>2020-10-22 12:48:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables<br>2020-10-22 12:48:26 0 [Note] InnoDB: Setting file &#8216;C:\\xampp\\mysql\\data\\ibtmp1&#8217; size to 12 MB. Physically writing the file full; Please wait \u2026<br>2020-10-22 12:48:26 0 [Note] InnoDB: File &#8216;C:\\xampp\\mysql\\data\\ibtmp1&#8217; size is now 12 MB.<br>2020-10-22 12:48:26 0 [Note] InnoDB: 10.3.16 started; log sequence number 249429331; transaction id 170022<br>2020-10-22 12:48:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\\xampp\\mysql\\data\\ib_buffer_pool<br>2020-10-22 12:48:26 0 [Note] Plugin &#8216;FEEDBACK&#8217; is disabled.<br>2020-10-22 12:48:26 0 [Note] Server socket created on IP: &#8216;::&#8217;.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Solution<\/h3>\n\n\n\n<p><strong>Step 1<\/strong>: Open Xampp Control Panel <br><strong>Step 2<\/strong>: Click on Config -&gt; Click on Service and Port Settings <br><strong>Step 3<\/strong>: Click on MySQL Tab and change port to 3307 (Note:  any other port which is free in your system) <br><strong>Step 4<\/strong>: Click on Save -&gt; Save.<br><strong>Step 5<\/strong>: Restart your Xampp Control Panel<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"671\" height=\"444\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/xampp-control-panel-view-main-1.jpg\" alt=\"\" class=\"wp-image-19050\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/xampp-control-panel-view-main-1.jpg 671w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/xampp-control-panel-view-main-1-300x199.jpg 300w\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"491\" height=\"440\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/configuration-of-control-panel-2.jpg\" alt=\"\" class=\"wp-image-19051\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/configuration-of-control-panel-2.jpg 491w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/configuration-of-control-panel-2-300x269.jpg 300w\" sizes=\"auto, (max-width: 491px) 100vw, 491px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"469\" height=\"261\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/mysql-port-change-view-3.jpg\" alt=\"\" class=\"wp-image-19052\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/mysql-port-change-view-3.jpg 469w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/mysql-port-change-view-3-300x167.jpg 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/mysql-port-change-view-3-355x199.jpg 355w\" sizes=\"auto, (max-width: 469px) 100vw, 469px\" \/><\/figure><\/div>\n\n\n\n<p><strong>Note : you have to change port number in my.ini files also.<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"773\" height=\"293\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/change-port-in-myini-files-4.jpg\" alt=\"\" class=\"wp-image-19053\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/change-port-in-myini-files-4.jpg 773w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/change-port-in-myini-files-4-300x114.jpg 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/10\/change-port-in-myini-files-4-768x291.jpg 768w\" sizes=\"auto, (max-width: 773px) 100vw, 773px\" \/><\/figure><\/div>\n\n\n\n<p>References : <\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\"  id=\"_ytid_53602\"  width=\"760\" height=\"427\"  data-origwidth=\"760\" data-origheight=\"427\" src=\"https:\/\/www.youtube.com\/embed\/rohn_3WlmE0?enablejsapi=1&#038;autoplay=0&#038;cc_load_policy=0&#038;cc_lang_pref=&#038;iv_load_policy=1&#038;loop=0&#038;rel=1&#038;fs=1&#038;playsinline=0&#038;autohide=2&#038;theme=dark&#038;color=red&#038;controls=1&#038;disablekb=0&#038;\" class=\"__youtube_prefs__  epyt-is-override  no-lazyload\" title=\"YouTube player\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>References :<br><a rel=\"noreferrer noopener\" href=\"https:\/\/stackoverflow.com\/questions\/47235252\/error-mysql-shutdown-unexpectedly-xampp\" target=\"_blank\">Click Here<\/a><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Solution 2<\/h4>\n\n\n\n<p><br>if you find error like below image attached then forward video upto 8:00 duration.<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/image-1-1024x576.png\" alt=\"\" class=\"wp-image-19959\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/image-1-1024x576.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/image-1-300x169.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/image-1-768x432.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/image-1-355x199.png 355w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/image-1.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>you have to locate below file and change localhost ipv4 address. whenever you change mysql port then you should change below file also to work smoothly.<\/p>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">\/xampp\/phpmyadmin\/config.inc.php (file)<\/code><\/span><\/pre>\n\n\n<p>old setting <\/p>\n\n\n\n<p>\/* Bind to the localhost ipv4 address and tcp *\/<br>$cfg[&#8216;Servers&#8217;][$i][&#8216;host&#8217;] = &#8216;<em><strong>127.0.0.1:3307<\/strong><\/em>&#8216;;<br>$cfg[&#8216;Servers&#8217;][$i][&#8216;connect_type&#8217;] = &#8216;tcp&#8217;;<\/p>\n\n\n\n<p>New Settings<\/p>\n\n\n\n<p>\/* Bind to the localhost ipv4 address and tcp *\/<br>$cfg[&#8216;Servers&#8217;][$i][&#8216;host&#8217;] = &#8216;<strong><em>127.0.0.1<\/em><\/strong>;<br>$cfg[&#8216;Servers&#8217;][$i][&#8216;connect_type&#8217;] = &#8216;tcp&#8217;;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Errors : mysql_error.log 2020-10-22 12:48:24 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2020-10-22 12:48:24 0 [Note] InnoDB: Uses event mutexes2020-10-22 12:48:24 0 [Note] InnoDB: Compressed tables use zlib&#8230; <\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[5150],"tags":[493],"class_list":["post-19048","post","type-post","status-publish","format-standard","hentry","category-php","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/19048","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=19048"}],"version-history":[{"count":8,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/19048\/revisions"}],"predecessor-version":[{"id":19964,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/19048\/revisions\/19964"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=19048"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=19048"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=19048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}