MySQL Bugs: #58973: MySQL 5.5.8 does not start on MacOS X

Bug #58973	MySQL 5.5.8 does not start on MacOS X
Submitted:	16 Dec 2010 13:36	Modified:	17 Dec 2010 23:16
Reporter:	Ralph Martin	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S1 (Critical)
Version:	5.5.8	OS:	MacOS (10.5.6, 10.6.5)
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	regression

Description:
MySQL installed from the MacOS X package does not start up. The PreferencePane supplied does not start it, and if I try to start it by hand, I see this:

sudo /usr/local/mysql/support-files/mysql.server start

/usr/local/mysql/support-files/mysql.server: line 256: my_print_defaults: command not found
Starting MySQL
 ERROR! Couldn't find MySQL server (./bin/mysqld_safe)

How to repeat:
Install MySQL 5.5.8 on a Mac. Try to start it.

it worked fine in 5.1.x

Verified just as described:

macbook-pro:~ openxs$ sudo /usr/local/mysql/support-files/mysql.server start
/usr/local/mysql/support-files/mysql.server: line 256: my_print_defaults: command not found
Starting MySQL
 ERROR! Couldn't find MySQL server (./bin/mysqld_safe)
macbook-pro:~ openxs$ ls -l /usr/local/ | grep mysql
lrwxr-xr-x   1 root  wheel   35 15 гру 19:23 mysql -> mysql-advanced-5.5.8-osx10.5-x86_64
drwxr-xr-x   4 root  wheel  136 19 тра  2009 mysql-5.1.31-osx10.5-x86_64
drwxr-xr-x  17 root  wheel  578  1 кві  2009 mysql-5.1.34-osx10.5-x86
drwxr-xr-x  17 root  wheel  578 14 лип  2009 mysql-5.1.37-osx10.5-x86_64
drwxr-xr-x  17 root  wheel  578 22 бер  2010 mysql-5.1.45-osx10.5-x86_64
drwxr-xr-x  17 root  wheel  578  6 кві  2010 mysql-5.1.46-osx10.5-x86_64
drwxr-xr-x  17 root  wheel  578  6 тра  2010 mysql-5.1.47-osx10.5-x86_64
drwxr-xr-x  17 root  wheel  578  4 чер  2010 mysql-5.1.48-osx10.5-x86_64
drwxr-xr-x  17 root  wheel  578  3 сер 22:43 mysql-5.1.50-osx10.5-x86_64
drwxr-xr-x  17 root  wheel  578 13 вер 19:15 mysql-5.1.51-osx10.5-x86_64
drwxr-xr-x  17 root  wheel  578 12 жов 02:03 mysql-5.1.52-osx10.5-x86_64
drwxr-xr-x  17 root  wheel  578  5 лис 04:42 mysql-5.1.53-osx10.5-x86_64
drwxr-xr-x  16 root  wheel  544  3 гру 20:24 mysql-advanced-5.5.8-osx10.5-x86_64
macbook-pro:~ openxs$ echo $PATH
/opt/local/bin:/opt/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
macbook-pro:~ openxs$ sudo /usr/local/mysql-advanced-5.5.8-osx10.5-x86_64/support-files/mysql.server start
/usr/local/mysql-advanced-5.5.8-osx10.5-x86_64/support-files/mysql.server: line 256: my_print_defaults: command not found
Starting MySQL
 ERROR! Couldn't find MySQL server (./bin/mysqld_safe)

Now, the same script from 5.1.x works:

macbook-pro:~ openxs$ sudo /usr/local/mysql-5.1.53-osx10.5-x86_64/support-files/mysql.server start
Starting MySQL
. SUCCESS! 
macbook-pro:~ openxs$ ps aux | grep mysqldopenxs   39703   0.0  0,0   599780    456 s001  R+    7:07     0:00.00 grep mysqld
_mysql   39701   0.0  0,9  2882344  36028 s001  S     7:06     0:00.10 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/macbook-pro.err --pid-file=/usr/local/mysql/data/macbook-pro.pid
root     39629   0.0  0,0   600252    808 s001  S     7:06     0:00.02 /bin/sh ./bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/macbook-pro.pid

Duplicate of bug#51264.  I just pushed a patch which fixes this.