MySQL shutdown unexpectedly, blocked port, missing dependencies, improper privileges | XAMPP | PHP

⇒ If you get this type of error
⇒ [Error: MySQL shutdown unexpectedly.
This may be due to a blocked port, missing dependencies,
improper privileges, a crash, or a shutdown by another method.
Press the Logs button to view error logs and check
the Windows Event Viewer for more clues
If you need more help, copy and post this
entire log window on the forums]

⇒ Don't worry
⇒ Follow these steps...
⇒ In my case, I have installed my XAMPP in D: drive but maybe you guys install your XAMPP in C: drive, so

⇒ 1. Open XAMPP folder (which means, open that file location where your XAMPP is installed).
⇒ 2. Now, select the MySQL folder and open it.
⇒ 3. change the data folder with a different name and create a new folder with the data name.
Warning: Don't delete your data folder, if you delete your data folder you'll lose your all databases,
only change the name of the data folder.
⇒ 4. Now, open your backup folder and copy all files except ibdata1.
(means copy all files of the backup folder into the data folder and delete the ibdata1 file)
⇒ 5. Now, copy the ibdata1 file from your old data folder.
⇒ 6. And if you want to take a backup of all your databases, then copy all database folders from the old data folder.
⇒ 7. Close all tabs and open your XAMPP server.

⇒ 8. Still, if you are getting the same error, restart your PC or sometimes wait or open and close your XAMPP server 3-4 times.

⇒ 9. Now, I can access my all databases.

⇒ Now, Everything work properly.


Thanks, guys
Subscribe to our "Free Projects1" YouTube channel
‪@freeprojects1‬

#php #xampp #xamppmysql #xamppserver #bholusingh #getfreesourcecode #projects #free #developerbholusingh #bolusinghblogger #bholusinghgithub

follow on social media also
GitHub:
github.com/BHOLU-SINGH

Facebook:
www.facebook.com/freeprojects1/

Instagram:
www.instagram.com/freeprojects1/

Medium:
medium.com/me/stories/public

Blogger:
freeprojects1.blogspot.com/


@freeprojects1
Thanks for watching…