1STOP! Please do NOT delete ibdata1 file!
2
3Deleting this file is like playing a Russian roulette with your databases, it could work and restablish everything, but also, probably could leave unusable every database you have.
4
5Instead, first try using the MySQL backup folder which is included with XAMPP. So do the next:
6
7Rename the folder mysql/data to mysql/data_old (you can use any name)
8Create a new folder mysql/data
9Copy the content that resides in mysql/backup to the new mysql/data folder
10Copy all your database folders that are in mysql/data_old to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)
11Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
12Start MySQL from XAMPP control panel
13And, voilà!
11. Exit Xampp and navigate to xampp/mysql/data directory
22. delete the ibdata1 file
33. restart the XAMPP server
4
5or
6
71. Exit Xampp and navigate to xampp/mysql/data directory
82. delete the ibdata1, ib_logfile0,ib_logfile1,ib_logfile101 files
93. restart the XAMPP server
10
11or
12
13Try to check the error log at the installed location: /xampp/mysql/data/mysql_error.log
14This can help you better debug the problem.
15Also Note:
16
171. XAMPP might hit into port issue when you have skype also running.
182. There is a federated plugin issue that is common.
11. Exit Xampp and navigate to xampp/mysql/data directory
22. delete the ibdata1 file
33. restart the XAMPP server
4
5or
6
71. Exit Xampp and navigate to xampp/mysql/data directory
82. delete the ibdata1, ib_logfile0,ib_logfile1,ib_logfile101 files
93. restart the XAMPP server
10
11or
12
13Try to check the error log at the installed location: /xampp/mysql/data/mysql_error.log