How to make MySQL working on Mac OS X

Installing and configuring MySql in Mac was such a pain for me. I have installed and run MySql on Windows and Linux systems at least for 20 times by now, without any trouble. I assumed it will be quite simple in Mac as well. Actually, I hoped for easy installation because Apple products are considered user-friendly....but not developer friendly :(

Anyhow, I got it working now :)
1- Download binary from Mysql downloads
2- Copy /usr/local/mysql/support-files/my-medium.cnf to /etc/my.cnf
3- Start MySql using : /usr/local/mysql/support-files/mysql.server start
4- Stop MySql using : /usr/local/mysql/support-files/mysql.server stop
5- Check MySql Status: ps xa | grep "/usr/local/mysql/bin/[m]ysqld"

You may get some errors in bin dir path. You may want to fix paths in /usr/local/mysql/support-files/mysql.server (at least I did)

I have installed Workbench GUI for administration purpose. Good enough to give a try !

No comments:

Post a Comment

Scheduling Repeating Local Notifications using Alarm Manager

Learn about Scheduling Repeating Local Notifications using Alarm Manager in this post .