10.6.5 and MySQLCOM not starting

Many of those steps are out-of-date. The following thread:
http://discussions.apple.com/thread.jspa?messageID=12229472&#12229472
has the latest settings you should use for MySQL on MacOS X. In particular, Apple changed some default socket paths so that they were consistent and in a more secure locations. You are reverting back to the old locations. Plus, it is better to use launchd instead of startup items. I don't know why MySQL has never done that. It has only been 6 years now I think.

After following catalinpetrisor solution and also resolving the Insecure startup item alert at bootup, mysql 5.5 works just fine on my 10.6.5 64bit desktop edition. I just summarized what needs to be done on this link - http://jaykhimani.blogspot.com/2010/12/mysql-55-startup-problems-on-os-x-1065.ht ml. Hope these 2/3 steps should resolve this issue.

I found a super easy fix to this problem here: http://www.artin.org/geekblog/2010/12/installing-mysql-5-5-8-on-mac-os-x-snow-le opard/

To quote:
1. Drop into Terminal.app
2. Type: sudo /Applications/TextEdit.app/Contents/MacOS/TextEdit /usr/local/mysql/support-files/mysql.server
3. Find the line starting with basedir and datadir and replace with:
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
4. Save the file
5. Start MySQL using the System Preferences pane button.

Worked like a charm!

mgl2nd wrote:
I found a super easy fix to this problem here: http://www.artin.org/geekblog/2010/12/installing-mysql-5-5-8-on-mac-os-x-snow-le opard/

To quote:
1. Drop into Terminal.app
2. Type: sudo /Applications/TextEdit.app/Contents/MacOS/TextEdit /usr/local/mysql/support-files/mysql.server
3. Find the line starting with basedir and datadir and replace with:
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
4. Save the file
5. Start MySQL using the System Preferences pane button.

Worked like a charm!

I'd had the same problem with new mysql release, a combination to catalinpetrisor and this one - mgl2nd - (I'd add basedir to /etc/my.cnf too), and now, works kinda normal way ... sigh ...

Hope all you resolve these stuffs with mysql 5.5.8 🙂

Message was edited by: VieL

Just for the record, I have this exact issue. I start it manually with no problem, but have been too busy to dig into the issue. I thought it was something I did wrong.

mgl2nd thank you this did work for me. Strange that this information is not saved into the script.

Awesome! Thanks for the fix, I have been struggling for weeks with this issue and your post resolved my issue!

Thanks again.

Wes

Thank you so much Debenriver and everybody who helped 🙂
I installed MySQLCOM many times and couldn't figure out what was wrong this time!
I wish I had read this post before 😝
All the best.