Today, I'll show you how to fix a problem with MySQL in XAMPP not running on the latest version of OS X, 10.11 El Capitan. This tip might also work on the previous version of OS X, 10.10 Yosemite.
Here's the code to type: unset DYLD_LIBRARY_PATH
--
If you enjoyed this video, please make sure to like it! And if you want more how-to videos, then subscribe to HandyAndy Tech Tips to get all of my latest tutorials.
--
PARTIAL VIDEO TRANSCRIPT:
Hi, it's HandyAndy Tech Tips here, and today I'm going to be telling you how to fix a really annoying bug with the version of MySQL
bundled with XAMPP. Now, on some people's Macs - and this has been known to happen under both Yosemite and El Capitan - MySQL just refuses to start - you can click the start button as many times as you like, and the status goes to Starting, and then eventually, after a long wait, goes back to stopped again. Here's two solutions to fix this bug.
So the fix that I'll show you first is the easiest one. Simply go to your Applications folder, scroll down a bit and double click on your XAMPP folder, find the etc folder and double click on that, and then inside this folder you will find a file called my.conf. You'll want to open this in a plain text editor like TextEdit. So I'll right click on the file, go to Open With, and then click on Other. It'll then open this window with all your installed applications. Just scroll down until you find TextEdit, and then click open. Now we've got the file open, and after finding this section down here, the one that begins with The MySQL server comment, you simply just want to change the port number, which is 3306 at the moment, to 3308. So do that, save the file, and close and reopen XAMPP. MySQL should start up perfectly!
But what if this fix simply doesn't work for you? Then, believe it or not, there's another option, but be warned that it is more challenging. So to start off with, you want to open your Applications folder, go to the XAMPP folder, and double click on xampp files. Now inside this folder, there should be a file called, quite appropriately, XAMPP! So you want to open this file with a plain text editor, so I'll right click on it, go to Open with, click Other, and then scroll down until I find TextEdit, and then click Open. So this is the file, and you can see that it looks a bit more complicated than the other one. But what we need to do is actually quite simple. Just scroll down until you find the function to start MySQL, so here it is, and then all you need to do is before this line, this XAMPP Root bin mysql server line, just type unset DYLD_LIBRARY_PATH. Just like this. If you want to make sure you type it correctly, I've put it in the description of this video, so you can simply copy and paste it in. Now all you need to do is save this file, close it, and then close and re-open XAMPP. You should have MySQL back up and running in no time.
So I hope that these solutions helped you solve the issue. If they did, then please subscribe to my channel for more tech videos, and do feel free to give this video a like. I'm HandyAndy and thank you so much for watching!
--
Why MySQL won't start on OS X 10.11 El Capitan, and how to fix it (XAMPP)
20 окт 2015
