Error MySQL shutdown unexpectedly in Xampp | Easiest way to solve this

hello everyone this is Yamin and in this tutorial I am going to show you a solution of MySQL shutdown unexpectedly so here you can see uh my Apache is running but every time I start my MySQL here we can see it started and then it will shut down unexpectedly and this may be due to block Port missing dividences and some other issue is set over here so to solve this issue what you have to do is that first of all you need to go to the folder where you install xampp so for my case I will go to my folder and I download my xampp inside local dxc so I'll go inside local DC then I'll choose this folder same and inside this Jam folder I'll directly go to mySQL folder here you can see we have the folder called MySQL over here just click on MySQL and then here you can see backup and data folder so I can see data folder first of all what we will do is that we will rename this data folder to let's say data underscore old and after that we will create a folder over here new folder let's just right click over here then click new then folder and we'll name it data okay so right now what we'll do is that we'll copy some folder from this data old and paste it inside this data folder so let's go inside this dataold folder and we will copy all the folder from here so let me just copy everything but except three folder from here here you can see MySQL performance schema and PSP my admin but we will also copy a file from here we will not copy any file from here but just only on and that is IB data on which is this one here you can see IB data one we'll copy this one so we'll just select this as well and then we'll copy everything from here so we'll copy it and then we'll go to our data folder which is empty and we'll paste every folder and file over here so we copy and paste some folder and file from the dot our folder so right now we'll go to our backup folder and from this backup folder we'll select everything but except this time will not copy this IB data one so we will not select it so we will copy every file except I beta down from here so I will just copy it and we'll go to mySQL then data over here and we'll paste it over here and then this may pop out that replace the file in destination just click on this you replace the file in destination and there you go you are ready to start your exam so if I now go to my exam and if I now start over here click Start here you can see it started and it's not shutting down as you can see so right now let's go to our browser let's go to our Sam let's click pism admin and there you can see we are able to successfully go to our PSP my admin so this how you can solve the issue MySQL shutdown unexpectedly so I hope this detail was useful to you and if this video is helpful make sure to give a like and leave a comment and I'll actually repeat it if you subscribe this channel thanks again for watching I'll see you in the next tutorial

Channel: Web Tech Knowledge

Views: 25,533

Keywords: mysql shutdown unexpectedly, error: mysql shutdown unexpectedly, mysql shutdown unexpectedly xampp, xampp mysql error, error mysql shutdown unexpectedly, mysql shutdown unexpectedly xampp error, xampp mysql shutdown unexpectedly, xampp error mysql shutdown unexpectedly fix, xampp error apache shutdown unexpectedly fix, mysql not starting in xampp, how to fix the xampp error mysql shutdown unexpectedly, apache shutdown unexpectedly, mysql shutdown unexpectedly in xampp

Id: iAlVsOtzKag

Length: 3min 42sec (222 seconds)

Published: Sun Feb 19 2023