MySQL Bugs: #57790: Install issue with mysql-5.5.6-rc-osx10.6-x86

Bug #57790	Install issue with mysql-5.5.6-rc-osx10.6-x86_64 on new MacBookPro with 10.6.4
Submitted:	28 Oct 2010 5:35	Modified:	9 Feb 2011 18:42
Reporter:	george weis	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.5.6, 5.5.8	OS:	MacOS (10.6.4)
Assigned to:		CPU Architecture:	Any

Description:
After installing above on new MacBookPro, could not start Mysql due to following:

Insecure Startup Item disabled

"/Library/StartupItems/MySQLCOM" has not been
started because it does not have the proper security
settings.

I cannot figure out how to alter security settings.
Tried to uninstall without success.
Very disappointing.  Want to use Archivist's Toolkit for Fox Island History Museum, WA.

How to repeat:
No idea.  I installed and have been stuck ever since.

THANKS FOR ANY HELP!!

George Weis
gaweis@gmail.com
253-549-8130

Have the identical problem after installing MySQL 5.5.7rc on an iMac running OS X 10.6.5. 

I get the "Insecure Startup Item disabled" message every time I log into my Mac account. The MySQL pref pane reports the MySQL Server Instance is stopped, and clicking "Start MySQL Server" does nothing. 

(You may classify this bug as "non-critical", but it prevents me from using MySQL.)

A solution for at least some of the reported problems installing for OS X can be found in this forum post: 
http://forums.mysql.com/read.php?11,399397,399606#msg-399606

(Instructions below; I used TextWrangler instead of TextEdit but achieved the same result.) 

--------------------------------------------------------------

Modify the mysql.server script file using the following command : 

sudo /Applications/TextEdit.app/Contents/MacOS/TextEdit /usr/local/mysql/support-files/mysql.server 

Locate the configuration defining the basedir and set the following : 
basedir=/usr/local/mysql 
datadir=/usr/local/mysql/data 

Save the file and start the mysql server in the system preferences / terminal

---------------------------------------------------------------

It appears that the OS X installer needs a little work.

I am still getting the message "insecure startup item disabled" whenever a user logs into the MySQL Mac (5.5.8). 

What is causing this and how can I make it stop?

See bug #57099 and the suggested fix concerning the installer's faulty written Group IDs (GIDs):

Bug #57099: False permissions of MySQL StartupItem on MacOSX prevent launchd to start MySQL
http://bugs.mysql.com/bug.php?id=57099

Fix:

$ sudo chown :wheel /Library/StartupItems/MySQLCOM/
MySQLCOM 
$ sudo chown :wheel /Library/StartupItems/MySQLCOM/
StartupParameters.plist

This is a duplicate of bug #57099.