How to Fix Error MySQL Shutdown Unexpectedly in XAMPP - Due to a Blocked Port Missing Dependencies
HTML-код
- Опубликовано: 19 авг 2024
- 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
Fisrt and Second method worked for me 100% . Thank you very much for this, it saved my day
Thank you, method 2 is working fine.
Anyone who has this problem, skip method 1 and just use method 2. Its solid at the moment -- 16.08.2024
You got my like on the video, good luck!
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 !
wrong number
1st and 2nd never worked for me but 3rd one was magicallll thankyouuuuu you literrally saved
I tried second method and it's worked 😊 thank you 🎉
first one works Thanks ! legit guys been scratching my head and this works ty
first method worked for me
thnkyou
im a beginner and its help me alot thbks
Thanks. Method 1 is working for me
first method work for me. Thank you
First Method Worked 🎉🎉❤
method 1 work, thanks dude, you're very helpful
The first method worked for me, thank u so much.
The First Method worked , thanks
Second method worked for me
Thank you 🙏🏼✅
Thank you bro, really appreciate it 😇
Thanks a lot mannnnn 1st method worked 👏
It's done.The third method is suitable for my Thank you😊.
hi, where to find the code that we have to copy please help cos the first and second method did not worked for me so i want to try the third one
2nd method worked! Thanks😊
Thank you very much, method 2 worked for me.
Thankss a lot, sir method 1 worked!💯
First method successful, no need for second.
first method work for me , tnq
Thank you so much it worked❤
2 method worked bro thanks a lot😉
Thank you, man❤ method 2 worked
❤❤❤it's working after a many methods
thanks a lot, sir. method 1 worked!
if there was a way i could give you more likes, i would have give you 100000000000000 likes.
you have helped me
thank you very much, it a really help me lot!!
It really helps me a lot, thankiess.
You are awesome. Thank you so much.
thanks a lot the fisrt method its worked
thanks bro method 2 work on me
It's working ❤ thank you so much
Thanks method 2 worked🎉
Thanks po! you deserve a Subscribe.
Love You Method 2 worked
thank yuouououououuououou the 2nd method worked
i'm searching for the method 2
Thankyou
First method working 100%
very helpful
Thanks!!
Thank you very very very much
Thank you bro
Thans bro,
Working 🎉 thank 🙂
Thank you so much
IT'S WORKING 100%❤❤
Thank you so much my error got fixed #method_2
thanks a lot
Thank You!
thank you so much
thanks it worked!!
Thank you❤
Thanks brother
sangat membantu, terima kasih
First method work
thnkzz broo its working
It's work ❤🔥
thank u sure >>
2nd one is working
thx
solve the issue thank you
muchas gracias, me funciono el segundo metodo !!
best
Try second method then try first
It's works!
G.O.A.T
Its working
It is working
its working