☰

我应该以谁的身份在个人计算机上运行 mysql？

tag-icon • tag-icon installation osx-mountain-lion homebrew mysql5
我应该以谁的身份在个人计算机上运行 mysql？

我刚刚安装mysql通过自制（使用brew install mysql，在 Mac OS X Mountain Lion 上 - 最近从头开始安装）。安装后，有一个“注意事项”部分，其中包含有关需要采取的进一步必要措施的选项：

==> Caveats
Set up databases to run AS YOUR USER ACCOUNT with:
    unset TMPDIR
    mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp

To set up base tables in another folder, or use a different user to run
mysqld, view the help for mysqld_install_db:
    mysql_install_db --help

and view the MySQL documentation:
  * http://dev.mysql.com/doc/refman/5.5/en/mysql-install-db.html
  * http://dev.mysql.com/doc/refman/5.5/en/default-privileges.html

To run as, for instance, user "mysql", you may need to `sudo`:
    sudo mysql_install_db ...options...

Start mysqld manually with:
    mysql.server start

    Note: if this fails, you probably forgot to run the first two steps up above

A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.

To connect:
    mysql -uroot

To launch on startup:
* if this is your first install:
    mkdir -p ~/Library/LaunchAgents
    cp /usr/local/Cellar/mysql/5.5.27/homebrew.mxcl.mysql.plist ~/Library/LaunchAgents/
    launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

* if this is an upgrade and you already have the homebrew.mxcl.mysql.plist loaded:
    launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
    cp /usr/local/Cellar/mysql/5.5.27/homebrew.mxcl.mysql.plist ~/Library/LaunchAgents/
    launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

You may also need to edit the plist to use the correct "UserName".

在以前的 Mac OS XI 版本中，mysql 以mysql用户身份运行，但现在我面临着以自己的身份运行它的想法。我是唯一使用这台计算机（碰巧是我的笔记本电脑）的人，我编程是为了工作和娱乐。

在选择是否运行 mysql 时，有哪些优缺点或最佳实践？作为您的用户账户或mysql或者还有其他的吗？

相关内容