Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

10.6.5 and MySQLCOM not starting

Automatic startup of MySQL server under 10.6.5 doesn't seem to work although MySQL can be started manually.
On startup (or fast user switching) following alert is displayed:

Insecure Startup Item disabled.
“/Library/StartupItems/MySQLCOM” has not been started because it does not have the proper security settings.

Any ideas ?
(No update yet seen on MySQL site)

MacBook Pro Core 2 Duo, MacBook Core 2 Duo, PowerBook G4, iMac G4, iMac G3, Mac OS X (10.6.4), 2.33 GHz 3 GB RAM disk 160 MB, iPhone 3G 4.0.2

Posted on Nov 11, 2010 12:46 AM

Best reply

catalinpetrisor

Level 1

10 points

Posted on Nov 11, 2010 2:20 AM

I experienced the same minutes ago and this is what I found in Console All Messages:

/System/Library/CoreServices/SecurityFixer.app/Contents/MacOS/SecurityFixer[617] "/Library/StartupItems/MySQLCOM" failed security check: not owned by GID 0

So what I did was:
sudo chown -R root:wheel /Library/StartupItems/MySQLCOM

After that I logged out and found this message in Console All Messages:

SecurityFixer[912] No insecure startup items found!

So I guess problem is solved.
Hope it helps. Good luck!

View in context

23 replies

etresoft

Level 8

46,524 points

Dec 28, 2010 9:15 PM in response to debenriver

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.

Dec 28, 2010 11:28 PM in response to eddy kestemont

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.

mgl2nd

Level 1

6 points

Dec 29, 2010 1:31 PM in response to eddy kestemont

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!

VieL

Level 1

0 points

Jan 10, 2011 12:49 PM in response to mgl2nd

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

Jan 12, 2011 7:30 AM in response to eddy kestemont

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.

dioioib

Level 1

0 points

Jan 24, 2011 9:55 AM in response to mgl2nd

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

tanney

Level 1

1 points

Feb 2, 2011 1:44 PM in response to Riquez

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

Thanks again.

Wes

Feb 4, 2011 2:03 AM in response to debenriver

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.

10.6.5 and MySQLCOM not starting