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