Friday 17 October 2014

How to start MySQL server via XAMPP on OSX 10.10 (Yosemite)

I just upgraded my Mac to the new OS Yosemite and everything works perfectly except I cannot start mysql server on XAMPP.

I've been google-ing for fixes provided by others but I can hardly find the proper solution. Thanks to the post here I finally got it working again.

Here are steps:

1. Install Homebrew

ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

2. Allow homebrew to install duplicates of system software

brew tap homebrew/dupes

3. Install libiconv and sqlite3

brew install libiconv
brew link libiconv -force
brew install sqlite3
brew link sqlite3 -force

4. Delete dylib from XAMPP package

cd /Applications/XAMPP/xamppfiles/lib
sudo rm libsqlite3.dylib libsqlite3.0.8.6.dylib libiconv.2.dylib libiconv.dylib

5. Start MySQL server from the manager-osx.app in /Applications/XAMPP