How do I change MYSQL startup options on Mac??? (can't work it out)

rubyonrails-talk
#1

Hi,

Can anyone help me out re how I change the startup options for mysql
(v5.0) running on my Mac? (I just want to add the “–log” option is
about it). I tried doing “sudo ./Library/StartupItems/MySQLCOM/MySQLCOM
restart” however this started a 2nd instances of mysql & mysqld.

Here is what I see start after Mac startup if this helps:

$ ps aux | grep mysql

_mysql 137 0.0 0.5 635228 9760 ?? S Wed03PM 2:47.21
/usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql
–datadir=/usr/local/mysql/data --user=mysql
–pid-file=/usr/local/mysql/data/Macintosh-2.local.pid

root 100 0.0 0.0 600172 496 ?? S Wed03PM 0:00.02 /bin/sh
./bin/mysqld_safe --datadir=/usr/local/mysql/data
–pid-file=/usr/local/mysql/data/Macintosh-2.local.pid

greg 53283 0.0 0.0 599700 372 s002 R+ 11:44AM 0:00.00 grep mysql

QUESTION: So how can I determine what Mac startup component/files culminate in the above-mentioned mysqld & mysql startup?

Thanks

#2

If you used the package installer from the MySQL site, you should have gotten a control panel, which you will find in your System Settings. If it isn’t there, it’s probably somewhere on the disk image of the MySQL installer. Just doubleclick it to install.

If you have compiled MySQL yourself, you probably used a LaunchDaemon, in which case you would edit the launchdaemon plist file and add the parameter in there.

Unloading a launchdaemon: sudo launchctl unload -w /Library/LaunchDaemons/com.mysql.blabla.plist

Loading a launchdaemon: sudo launchctl load -w /Library/LaunchDaemons/com.mysql.blabla.plist

Best regards

Peter De Berdt

#3

Hi,

My MySQL icon in System Preferences is quite basic. Nowhere to put in mysqld startup parameters.

I don’t have any LaunchDaemons, so it seems it started from ./Library/StartupItems/MySQLCOM/MySQLCOM, however I still haven’t quite determined where to put the startup parameters. I’ll have to try to understand the MySQLCOM shell script I guess and work it out…

#4

On my machine, there’s a file called /Library/StartupItems/MySQLCOM/StartupParameters.plist in that directory that has this XML. Perhaps this is enough to figure things out - Al

Description MySQL 5.0.41 OrderPreference None Provides MySQL Uses Network Resolver
#5

Hi,

My MySQL icon in System Preferences is quite basic. Nowhere to put
in mysqld startup parameters.

I don't have any LaunchDaemons, so it seems it started from ./
Library/StartupItems/MySQLCOM/MySQLCOM, however I still haven't
quite determined where to put the startup parameters. I'll have to
try to understand the MySQLCOM shell script I guess and work it
out....

Probably easier to just change the options in /etc/my.cnf (or wherever
you mysql config file is)

Fred

#6

I tried putting a key/value pair here for the options but it didn’t pick it up :frowning:

#7

I’ll give this a go Fred…