Bug #57151 MySQL 5.5.6.rc cannot be started from the PrefencePane
Submitted: 30 Sep 2010 19:59 Modified: 8 Oct 2010 21:26
Reporter: Larry D. Wilson Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:5.5.6rc OS:MacOS (10.6.4)
Assigned to: CPU Architecture:Any
Tags: 5.5.6.rc, cannot start, osx, PreferencePane

[30 Sep 2010 19:59] Larry D. Wilson
Description:
After installation, MySQL cannot be started from the PrefencePane. Installation of the 32bit or 64bit instance gives the same results. 

How to repeat:
First, remove all MySQL files to insure a clean install:
sudo rm -Rf /usr/local/mysql*
sudo rm -f /etc/my.cnf
sudo rm -Rf /Library/PreferencePanes/MySQL.prefPane

Download mysql-5.5.6-rc-osx10.6-x86.dmg 
(same behavior exists for 32 bit download)

Open the dmg.

Double-click on mysql-5.5.6-rc-osx10.6-x86_64.pkg and follow the instructions.

Double-click on MySQL.prefPane and select "for all users".

From the Preference Pane, click "Start MySQL Server". The server will not start.

From the logs:
9/30/10 2:43:35 PM	Installer[4778]	MySQL 5.5.6-rc-community for Mac OS X  Installation Log
9/30/10 2:43:35 PM	Installer[4778]	Opened from: /Volumes/mysql-5.5.6-rc-osx10.6-x86_64/mysql-5.5.6-rc-osx10.6-x86_64.pkg
9/30/10 2:43:46 PM	Installer[4778]		Upgrade: "MySQL 5.5.6-rc-community for Mac OS X"
9/30/10 2:44:02 PM	installd[4787]	Installed "MySQL 5.5.6-rc-community for Mac OS X" ()
9/30/10 2:44:21 PM	System Preferences[4808]	stat /usr/local/mysql/data

There are no error logs created in the data directory of the mysql installation. 

The database server WILL start if you:
cd /usr/local/mysql/bin
./mysql -u root

and after mysqld_safe has been run, an error log file exists in the data directory.
[8 Oct 2010 21:26] Sveta Smirnova
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of bug #51264
[20 Oct 2010 12:46] Alvaro Oliveira
I was able to reproduce the problem on 10.6.4

I just had a mysql 5.1 version working, deleted everything for a clean install

Downloaded the new 5.5rc package (32bits), installed. 

The installation was OK, the PrefPane got installed. 

But if I click Start Server, it prompts for my admin password, and after that it just stays there. It won't do anything, does not show any errors, but does not start the server.

If I start from the command line, it works perfectly. The PrefPane is able to show that the server is running.

The PrefPane *is* able to stop the server properly.

This is the error that shows up in the Mac OS Console Log :
10/20/10 10:45:25 AM	[0x0-0x39039].com.apple.systempreferences[2494]	/usr/local/mysql/support-files/mysql.server: line 256: my_print_defaults: command not found

Thanks.
[20 Oct 2010 12:49] Alvaro Oliveira
Sorry. 
I've added the comment to the wrong tab on my browser. 

Added the same comment on the other thread.