MySQL 5.5.10-Mac 10.6.x-自动启动 [英] Mysql 5.5.10 - Mac 10.6.x - auto start

问题描述

我正在尝试在Mac Pro上自动启动mysql 5.5.10社区服务器(gpl).我已经在该论坛上阅读了多个主题.我仍然感到困惑，因为那些线程引用了一个文件:

I'm trying to automatically start mysql 5.5.10 community server (gpl) on my mac pro. I've read several threads on this forum. I'm still baffled, because those threads refer to a file:

/Library/StartupItems/MySQLCOM

我似乎没有此文件或文件夹.

I don't seem to have this file or folder.

有人可以帮忙吗?

顺便说一句，我可以使用mysqld启动mysql ...，它可以正常工作.

btw, I can start mysql using mysqld...and it works fine.

提前谢谢！

推荐答案

您实际上必须创建此文件...最佳方法是使用符号链接:

You actuall have to create this file... Best way is with a symlink:

mkdir /Library/StartupItems/MySQLCOM
cd /Library/StartupItems/MySQLCOM/
ln -s /path/to/installation/mysql/support-files/mysql.server MySQLCOM

但是我不建议这样做.您应该正确执行此操作，而应使用launchd-这是OS X的正确方法:-)

However I wouldnt recommend this. You should do it proper and use launchd instead - this is the proper OS X way :-)

首先在/Library/LaunchDaemons/com.mysql.mysqld.plist

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
    <key>Disabled</key>
    <false/>
    <key>GroupName</key>
    <string>_mysql</string>
    <key>KeepAlive</key>
    <true/>
    <key>Label</key>
    <string>com.mysql.mysqld</string>
    <key>Program</key>
    <string>/usr/local/mysql/bin/mysqld</string>
    <key>ProgramArguments</key>
    <array>
        <string>--user=_mysql</string>
    </array>
    <key>RunAtLoad</key>
    <true/>
    <key>Umask</key>
    <integer>7</integer>
    <key>UserName</key>
    <string>_mysql</string>
    <key>WorkingDirectory</key>
    <string>INSTALL_PATH/mysql</string>
</dict>
</plist>

然后调整权限:

sudo chown root /Library/LaunchDaemons/com.mysql.mysqld.plist
sudo chgrp wheel /Library/LaunchDaemons/com.mysql.mysqld.plist
sudo chmod 644 /Library/LaunchDaemons/com.mysql.mysqld.plist

现在，MySQL应该在启动时启动.要测试一切是否正常运行而无需重新启动，您可以运行:sudo launchctl load com.mysql.mysqld.plist，然后检查错误日志中的消息.

Now MySQL should be launched on startup. To test that everything works without rebooting you can run: sudo launchctl load com.mysql.mysqld.plist then check your error logs for messages.

如果您需要添加特殊的args(如自定义日志，cnf等)，则可以通过在<key>ProgramArguments</key>之后的<array>元素中将它们指定为<string>元素来实现.这些<string>元素的值应该是与mysqld一起使用的标准开关.

IF you need to add special args (like custom logs, cnf, etc..) you can do so by specifying them as <string> elements in the <array> element following <key>ProgramArguments</key>. The values of those <string> element should be the standard switches you would use with mysqld.

这篇关于MySQL 5.5.10-Mac 10.6.x-自动启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！