How to Fix Error MySQL Shutdown Unexpectedly in XAMPP - Due to a Blocked Port Missing Dependencies

Рет қаралды 18,351

2 ай бұрын

Code 1: mysqld --console --skip-grant-tables --skip-external-locking
Code 2: mysqlcheck -r --databases mysql --use-frm
In This Video We Will See How to Fix Error Mysql Shutdown Unexpectedly in Xampp - This May Be Due to a Blocked Port Missing Dependencies
Here Are The Steps to Fix Error Mysql Shutdown Unexpectedly in Xampp - This May Be Due to a Blocked Port Missing Dependencies
Method 1
1. Click "File Explorer" to Open it
2. Go To The XAMPP Installation Location Where You Have Installed it. Default Installation Location is C:\xampp
3. Click This PC or Computer
4. Open C Drive
5. Scroll Down Until You Find xampp Folder
6. Open xampp Folder
7. Open mysql Folder
8. Now Copy The data Folder By Pressing CTRL + C on Your Keyboard or Right-Clicking on it & Click Copy
9. Now Paste The data Folder in Same Place By Pressing CTRL + V on Your Keyboard or Right-Clicking & Click Paste
10. Now Rename The "data - Copy" Folder to "data_old"
11. Now Open data Folder
12. Press & Hold Ctrl on Your Keyboard & Click on the mysql, performance_schema, phpmyadmin & test Folders One By One To Select All of Them
13. Now Delete the Selected Folders by Either Pressing Shift + Delete on Your Keyboard or Right-clicking on One of the Selected Folders, Pressing Shift on Your Keyboard, & Then Clicking 'Delete' From the List To Permanently Delete Them
14. Click Yes Button
15. Now Select All the Files Except for the Folders as Shown in the Video
16. Scroll Up Until You See ibdata1
17. Press & Hold Ctrl on Your Keyboard & Then Click on ibdata1 to Unselect it. (This Step is Important)
18. Now Delete the Selected Files by Either Pressing Shift + Delete on Your Keyboard or Right-clicking on One of the Selected Files, Pressing Shift on Your Keyboard, & Then Clicking 'Delete' From the List To Permanently Delete The Files
19. Click Yes Button
20. Now Click mysql in Address Bar to go to the mysql Folder
21. Now Open backup Folder
22. Now Select All The Files & Folders From Here
23. Now Press & Hold CTRL on Your Keyboard & Click on ibdata1 File To Unselect it. (This Step is Also Important)
24. Now Copy All The Selected Files & Folder
25. Now Click mysql in Address Bar to go to the mysql Folder
26. Open data Folder Again
27. Now Paste The Copied Files & Folders Here
28. Click Close
29. Open XAMPP
30. Now Start Apache & MySQL
31. Done! Error Fixed
Method 2
1. Click on the 'Config' Button Located in the MySQL Line
2. Click my.ini
3. Scroll Down Until You See [mysqld]
4. There are Two Port= Options, One Under the [Client] & One Under the [mysqld]. We Want to Change the Port Which is Under [mysqld]
5. Change the Port Under [mysqld] to different Number (I am Changing it from 3306 to 3307)
6. Click File
7. Click Save
8. Click Close
9. Click Explorer Button in Xampp To Open Xampp Installation Location. or You Can Also Go To The Xampp Installation Location Manually
10. Open phpMyAdmin Folder
11. Scroll Down Until You Find config.inc File
12. Now Open config.inc With Notepad By Right-Clicking on it
13. Click Open With
14. If There is Notepad in The List Then Click on it Otherwise Click "Choose another app"
15. If There is Notepad in The List Then Click on it Otherwise Click "More apps"
16. Scroll Down Until You Find Notepad in The List
17. Select Notepad By Clicking on it & Then Click OK Button
18. Scroll Down Until You Find "$cfg['Servers'][$i]['connect_type'] = 'tcp';" Under /* Bind to the localhost ipv4 address and tcp */
19. Now Copy The Line, "$cfg['Servers'][$i]['connect_type'] = 'tcp';".
20. Now Click With the Mouse At The End of The Copied Line.
21. Now Press Enter on Your Keyboard to add New Line Under Copied Line.
22. Now Paste the Copied Line on a New Line
23. Change 'connect_type' to 'port' in Pasted Line
24. Change 'tcp' to the Port Which You Set in MySQL my.ini File in Previous Step. (I Have Set Port To 3307 There So I Will Change 'tcp' to 3307)
25. Click File
26. Click Save
27. Click Close
28. Click Close
29. Close XAMPP
30. Again Open XAMPP
31. Now Start Apache & MySQL
32. Done! Error Fixed
Method 3
1. Click Shell Button in XAMPP
2. Copy 1st Code:- mysqld --console --skip-grant-tables --skip-external-locking
3. Paste the Code in Shell By Pressing CTRL + V & Then Hitting Enter on Your Keyboard
4. Go Back to XAMPP
5. Again Click Shell Button to Open Another Shell
6. Copy 2nd Code:- mysqlcheck -r --databases mysql --use-frm
7. Paste the Code By Pressing CTRL + V & Then Hitting Enter on Your Keyboard
8. Now Close Both the Shell Window
9. Close XAMPP
10. Again Open XAMPP
11. Start Both Apache & MySQL
12. Done! Error Fixed
Don't Forget To Like Share And Subscribe

Пікірлер: 54

@DeadRaw1 Ай бұрын

Its working, finally. yeaahhhhhhhhhhhhhhhhhhh!. Man love you , smile isn't going. We programmers might not be as happy hearing "I love you" from our partner as we are after resolving a difficult problem. 😂😂💗 God bless youuuuuuuuuuuuuuuuuuuuuuuuuu !

@HassanShahbaz-f6o 23 күн бұрын

wrong number

@palanisamy.g101 24 күн бұрын

I tried second method and it's worked 😊 thank you 🎉

@moh.bs10 Ай бұрын

The first method worked for me, thank u so much.

@saniaawan810 13 күн бұрын

first method worked for me thnkyou im a beginner and its help me alot thbks

@user-lk7hg5hn3n 13 сағат бұрын

It's done.The third method is suitable for my Thank you😊.

@mirroroftruth9795 11 күн бұрын

first one works Thanks ! legit guys been scratching my head and this works ty

@britsimarcelinoflores 16 күн бұрын

Thank you very much, method 2 worked for me.

@mianabubakar8110 Ай бұрын

thanks a lot, sir. method 1 worked!

@ruzanecraft0436 3 күн бұрын

method 1 work, thanks dude, you're very helpful

@Pradipmandhare-si6tl 5 күн бұрын

Second method worked for me Thank you 🙏🏼✅

@Supun_K 17 сағат бұрын

2nd method worked! Thanks😊

@FrancesMANALO-k8m 27 күн бұрын

It really helps me a lot, thankiess.

@bhuwanpandey3417 29 күн бұрын

You are awesome. Thank you so much.

@omsoni5854 12 күн бұрын

Thankss a lot, sir method 1 worked!💯

@LecxaAmador 5 күн бұрын

The First Method worked , thanks

@ali_harix 8 күн бұрын

Thanks a lot mannnnn 1st method worked 👏

@itsnoobdog 12 сағат бұрын

first method work for me , tnq

@lucasadrianopedroso2802 12 күн бұрын

thank you very much, it a really help me lot!!

@gowthamgm2044 Ай бұрын

i'm searching for the method 2 Thankyou

@PrakashAmb98 5 күн бұрын

2 method worked bro thanks a lot😉

@dhilukshandhilu4371 12 күн бұрын

Thank you, man❤ method 2 worked

@bagusadityaap 20 күн бұрын

thanks a lot the fisrt method its worked

@nikhilkumarsingh9466 8 күн бұрын

Thank you very very very much

@angelohijalga5329 25 күн бұрын

Thanks po! you deserve a Subscribe.

@tejushreer7688 24 күн бұрын

Thank you so much

@Poojahariramsingh 14 күн бұрын

Thanks method 2 worked🎉

@MRNani-rw6td 28 күн бұрын

❤❤❤it's working after a many methods

@weronika1128 Ай бұрын

Thank You!

@CatherineOtieno-g6r 16 күн бұрын

It's working ❤ thank you so much

@erycsaprones4514 9 күн бұрын

if there was a way i could give you more likes, i would have give you 100000000000000 likes. you have helped me

@bhargavkongara2003 Ай бұрын

Thank you so much my error got fixed #method_2

@danushadhaamarasekera7215 Ай бұрын

thank you so much

@Mdpere Ай бұрын

Thank you❤

@shrikantbhad2691 12 күн бұрын

thanks bro method 2 work on me

@SYEDAHMADALI-z4r 28 күн бұрын

Love You Method 2 worked

@akankshahodage6907 13 күн бұрын

Thank you bro

@falgunichhawchharia3362 23 күн бұрын

thank yuouououououuououou the 2nd method worked

@TrendingHubPH 8 күн бұрын

Thanks!!

@musthofafauzi9217 Күн бұрын

Thans bro,

@karthik_d0 24 күн бұрын

Thanks brother

@s.hazratkazimi9891 29 күн бұрын

First method working 100%

@Harshalsonawane-ov8yo 18 күн бұрын

Working 🎉 thank 🙂

@BeatsShift 24 күн бұрын

thanks it worked!!

@thoufeeknazeer3943 Ай бұрын

thnkzz broo its working

@Amzingvideso36 Ай бұрын

IT'S WORKING 100%❤❤

@afzalhussain9420 Ай бұрын

solve the issue thank you

@elkazinizakaria8490 23 күн бұрын

thank u sure >>

@athrun1848 25 күн бұрын

thx

@tanmaybhowmik6531 Ай бұрын

It is working

@eyesyt5626 Ай бұрын

its working

@RaushanKumar-hd9uj Ай бұрын

Its working

@eranda_kumara. 2 күн бұрын

It's work ❤🔥