sudo killall mysqld
then
sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start
#1. Open XAMPP Installation Directory
#2. Open "etc" Folder
#3. Find "my.cnf" file and open it in any text editor
#4. Change Port from 3306 to 3307 (if you have installed skype or other apps)
#5. Add "innodb_force_recovery=1" under "myisam_sort_buffer_size=8M"
#6. Save "my.cnf" file
#7. Restart Mysql Server By Your Terminal by command:
$ sudo killall mysqld
$ sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start
You Get A message "Starting MySQL SUCCESS! "
sudo service mysql stop
sudo /opt/lampp/lampp restart
sudo rm -rf ~/.bitnami // type this command in your terminal.
//THIS WILL SOLVE THIS PROBLEM BUT WILL DELETE ALL YOUR DATABASES
18
1
If you have MySQL already installed on your windows then go to services.msc file on your windows and right click the MySQL file and stop the service, now open your XAMPP and start MySQL. Now MySQL will start on the port 3306.