10.6.5 and MySQLCOM not starting

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!

I have the same problem and your suggestion fixed it – no startup message. Except that I cannot get MySQL to start up at all! On Terminal I get "can't connect to MySQL server through socket 'tmp/mysql.sock'. I changed the php.ini defaults from /var/mysql/mysql.sock to /tmp/mysql.sock but this hasn't made any difference.

I have previously installed it and had it working on both my macs with earlier systems (10.4 and 10.5). I have just done a complete erase and re-instal of 10.6 on the MacBook, which is why I need to re-instal MySQL etc. So it is a very clean instal.

I installed the 64 bit version of MySQL (I also tried the 32 bit version - but same problem).

Any help would be much appreciated - George

I have the same problem debenriver, mysql.sock is not on the system anywhere i can find & cant start mysql.

I've installed mysql countless times on os x & ive even had this mysql.sock issue before, but this time (new iMac i3 10.6.5) something else is awry & i'm stuck too.

ok, somehow my install is now working. sort of.

I say "somehow" because for about 4 hours I have been trying to find a solution & nothing was working. I didnt really make many significant or sensible changes, mostly googling & nothing was working or seemed to fit - then after pondering for 20 mins I suddenly noticed my mysql system pref window in the background was green & said "running"

I know this isnt entirely helpful, but here are the few changes i made in terminal... in order..

i didnt have /etc/php.ini
+$ sudo cp /etc/php.ini.default /etc/php.ini+
then i changed the 3 refs to mysql.sock to /tmp/mysql.sock in the new php.ini file
& chmod to 666

I tried to start mysql using this
+$ sudo /Library/StartupItems/MySQLCOM/MySQLCOM start+
Password:
Starting MySQL database server

(seemed to work but wasnt)

Then I cd'd to /usr/local/mysql
+sudo chown -R mysql data+

$ ./mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

****!

+$ sudo /usr/local/mysql/bin/mysqld_safe --user=mysql &+
$ 101219 21:44:46 mysqld_safe Logging to '/usr/local/mysql/data/oberon.local.err'.
101219 21:44:46 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

above might be it?

+$ sudo ln -s /usr/local/mysql/run/mysql_socket /var/mysql/mysql.sock+
Password:
ln: /var/mysql/mysql.sock: No such file or directory

Then I noticed mysql was running, so maybe in safe mode. Its a start.

At this point I was able to set root password
$ ./mysqladmin -u root password " ****"

mysql is running, i can connect using SequelPro. I have yet to see if it will stay up after reboot.

Never been though this much pain with mysql before, ive installed it on os x 30+ times & even with old mysql.sock probs its never been like this. im officially stumped this time.

sigh
it still didnt work after re-boot. I began to think that mysql 5.5 is just not playing well with OS 10.6.5

I removed mysql & installed version 5.1.49 - worked fine, no problems.

To remove mysql:

sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
edit /etc/hostconfig and remove the line MYSQLCOM=-YES-
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /var/db/receipts/com.mysql.*

Had exactly the same problem on OS X 10.6.5 with the 64bit build of MySQL server 5.5.8 as Debenriver and Riquez. Tried different tacks to get it to work to no avail. Downgraded MySQL server to the 64 bit build version 5.1.54. It installed and ran perfectly first time. Thanks Riquez for the deinstall sequence.

I've had exactly the same problem with 5.5

It all worked great right after installing it. However as soon as I restarted things started to go bad.

The service did not restart automatically... "unauthorized" it says, and then I could not restart it using the

sudo /Library/StartupItems/MySQLCOM/MySQLCOM start

command

I fiddled around with the /etc/my.cnf file and the local /usr/local/mysql/my.cnf and tried again and it worked!

But then I restarted and once again no joy.

Worse, now no matter what fiddling I did, it simply would not start.

After some further googling I tried the old fashioned way of starting mysql:

sudo /usr/local/mysql/bin/mysqld_safe

And it worked the first time.

So moral of the story... I personally think the startup script is no good. Maybe I'll take a look at it tomorrow morning.

Hope that helps a few people. This is with the newest 64bit mysql pkg from mysql community 5.5 distribution on Mac OS X Server 10.6

thanks Riquez - uninstall and reinstall of 5.1 works at least - wasted too much time trying to figure out 5.5 wont work!

Thanks Riquez.

Same problem. Tried workarounds that didn't solve anything.

Down to mySql 5.1.54

Tanks catalinpetrisor. MySQL works fine for me now.

I executed :

sudo chown -R root:wheel /Library/StartupItems/MySQLCOM

Thanks caalinpetrisor. Your solution worked.

Thanks to all who replied. I finally worked out a schema that worked! Here it is in the order I did it:

Activate PHP

Use a text editor that will find hidden files (like TextWrangler)

Navigate to /etc/apache2/httpd.conf

Find and uncomment (take away the #) the line: #LoadModule php5_module libexec/apache2/libphp5.so

Go to /etc/php.ini.default

Open and save a copy in the /etc directory as php.ini

Open php.ini

Find ;date.timezone =

Uncomment (take away the 😉 and enter your time zone – such as America/New_York (find time zones at http://php.net/manual/en/timezones.php)

Find:

pdo mysql.defaultsocket= /var/mysql/mysql.sock
mysql.default_socket = /var/mysql/mysql.sock
mysqli.default_socket = /var/mysql/mysql.sock

And change to:

pdo mysql.defaultsocket=/tmp/mysql.sock
mysql.default_socket = /tmp/mysql.sock
mysqli.default_socket = /tmp/mysql.sock

Go to System Preferences and turn on Web Sharing (if it is already on, turn it off and then on again)

Make a note of the path to your personal website (it will be something like http"//macintosh.home/~yourname/)

To test whether PHP is working make a simple PHP file with this single function:

phpinfo()

Save it as, say, phpinfo.php in your Home Directory/Sites. Then open it in your browser (something like http://macintosh.home/~yourname/phpinfo.php). This should come up with the PHP configuration of your PHP. If it comes up with the code instead, then PHP is not working.

MySQL

Download MySQL, Community Edition for Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive. If you have an older 32-bit machine, use the 32-bit download.

Open the disk image. Install (in order) mysql-5.5.8-osx10.6-x86_64.pkg, MySQLStartupItem.pkg, MySQL.prefPane. MySQL won't start at the moment.

Open Terminal

Type:

sudo chown -R root:wheel /Library/StartupItems/MySQLCOM

At this point probably best to do a restart.

Open Terminal

Type:

cd /usr/local/mysql to navigate to the mysql interface.

Type: sudo echo

You will be asked for your computer admin password

Then type:

sudo bin/mysqld_safe &

Then type:

bin/mysqladmin -u root password 'xxxxxxxx' to enter a root password for the MySQL database (replace xxxxxx with your chosen password. This should probably be different from your computer password. Don't forget the single quotes). Logout of Terminal.

Then look at System Preferences. Under "Other", click the MySQL button. It should say "The MySQL Server Instance is running". If you want MySQL to start on StartUp, check the box "Automatically Start MySQL Server on Startup"


phpMyAdmin

Download a suitable version of phpMyAdmin (I used phpMyAdmin-3.3.8.1-english.zip).

Move the entire folder to Home/Sites. Rename the folder something a bit more user-friendly (I renamed mine to PMA).

I used the Setup facility to produce config.inc. You can also hand code the config file from the sample file supplied.

First make a new folder in the PMA directory called config. Set the permissions for this folder (Apple-I) to Read and Write for everyone.

In your browser enter something like http"//macintosh.home/~yourname/PMA/setup

Click New Server. I used the following settings:

Server hostname: localhost
Server socket: socket
PHP extension: mysql
Authentication type: cookie
User for config auth: root
Password for config auth: The password you set for user "root"

Leave all the others blank.

Hit the Save button. If it can't save it is probably because you haven't set permissions correctly for the config folder.

You should now see your server #1, Name:localhost, Authentication type:cookie, DSN: mysql://

Under Configuration File you should see:

Default language: English (or the language you chose originally)
Default server: localhost[1]
End of Line: select Unix/Linux (\n)

Hit Download. This should download config.inc to your config folder.

Now go to the PMA folder (in Finder). Move config.inc out of the config folder into the main PMA foder. Throw away the config folder.

In your browser enter something like http"//macintosh.home/~yourname/PMA

You should get a screen asking for Username (root) and Password (the one you set). This will then go to the phpMyAdmin page where you will see the MySQL databases. Don't mess with the three MySQL databases. Don't use the database "test" because this is available to everyone. Instead use the "Create a new database" facility to make a new database and tables. Or use the SQL facility to do the same thing. You can set passwords and priveleges etc. for new databases.

I cannot thank debenriver and Riquez enough, and everyone on this forum. It is clear that MySQL 5.5 distribution from mysql.com is aimed at OS X Server edition, and is very problematic for the regular desktop version. Three days of frustration (and thinking I was losing my abilities), and of searching mysql.com's forums, all to no avail. Thank you, thank you thank you, all!

Reinstalling MySQL 5.1.54 solved this issue for me. Although manually starting MySQL 5.5 on Mac OS 10.6.5, it was still a pain to remember that command every time.

Thanks a lot guys for your help!