在 Mac 下用 Homebrew 安裝 MySQL, 網上的教程倒是很多，不過大多數都很默契地雷同。如果稍有點定制要求，就無從下手了。

我先也不免俗，從基本的開始：

一、首先安裝 Homebrew

$ ruby -e "$(curl -fsSL https://raw.github.com/mxcl/homebrew/go)"

$ brew install git

$ brew update

二、安裝 MySQL

用下面的命令就可以自動安裝了：

$ brew install mysql

安裝完成之后會有這樣的提示：

? ~ brew install mysql

==> Downloading https://homebrew.bintray.com/bottles/mysql-5.6.25.yosemite.bottle.tar.gz

######################################################################## 100.0%

==> Pouring mysql-5.6.25.yosemite.bottle.tar.gz

==> Caveats

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

server starting up correctly.

To connect:

mysql -uroot

To have launchd start mysql at login:

ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents

Then to load mysql now:

launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

Or, if you don't want/need launchctl, you can just run:

mysql.server start

==> Summary

🍺 /usr/local/Cellar/mysql/5.6.25: 9833 files, 339M

如果想讓 MySQL 開機自動啟動，可以如下操作：

$ mkdir -p ~/Library/LaunchAgents

$ ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents

$ find /usr/local/Cellar/mysql/ -name "homebrew.mxcl.mysql.plist" -exec cp {} ~/Library/LaunchAgents/ \;

$ launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

設置 MySQL 用戶以及數據存放地址

$ unset TMPDIR

$ mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp

好了，可以啟動了

$ mysql.server start

另外的參數還有?{start|stop|restart|reload|force-reload|status}

大部分的介紹就在此結束了。

三、更詳細的設置

配置文件 my.cnf

作為用慣了 Linux 的人， 一定會去?/etc?下找?my.cnf, 讓你失望了，這個文件要自己建立。如果看一下幫助

$ mysqld --help --verbose

就會發現系統會按這個順序去找 my.cnf

/etc/my.cnf

/etc/mysql/my.cnf

/usr/local/etc/my.cnf

~/.my.cnf

一般網上大蝦都會這么教小白建立 my.cnf, 其實這個默認的文件里面幾乎沒什么內容。

$ sudo cp $(brew --prefix mysql)/support-files/my-default.cnf /etc/my.cnf

所以，還是自己老老實實參考 linux 下的配置文件吧。

my.cnf (my.cnf.txt)download

#

# The MySQL database server configuration file.

#

# You can copy this to one of:

# - "/etc/mysql/my.cnf" to set global options,

# - "~/.my.cnf" to set user-specific options.

#

# One can use all long options that the program supports.

# Run program with --help to get a list of available options and with

# --print-defaults to see which it would actually understand and use.

#

# For explanations see

# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients

# It has been reported that passwords should be enclosed with

# ticks/quotes escpecially if they contain "#" chars...

# Remember to edit /etc/mysql/debian.cnf when changing

# the socket location.

[client]

port = 3306

#socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs

# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions

# are currently parsed.

[mysqld_safe]

#socket = /var/run/mysqld/mysqld.sock

#nice = 0

[mysqld]

#

# * Basic Settings

#

#

# * IMPORTANT

# If you make changes to these settings and your system uses

# apparmor, you may also need to also adjust

# /etc/apparmor.d/usr.sbin.mysqld.

#

#user = mysql

#socket = /var/run/mysqld/mysqld.sock

port = 3306

#basedir = /usr

datadir = /usr/local/var/mysql

#tmpdir = /tmp

skip-external-locking

#

# Instead of skip-networking the default is now to listen only on

# localhost which is more compatible and is not less secure.

bind-address = 127.0.0.1

#

# * Fine Tuning

#

key_buffer = 16M

max_allowed_packet = 16M

thread_stack = 192K

thread_cache_size = 8

# This replaces the startup script and checks MyISAM tables if needed

# the first time they are touched

myisam-recover = BACKUP

#max_connections = 100

#table_cache = 64

#thread_concurrency = 10

#

# * Query Cache Configuration

#

query_cache_limit = 1M

query_cache_size = 16M

#

# * Logging and Replication

#

# Both location gets rotated by the cronjob.

# Be aware that this log type is a performance killer.

# As of 5.1 you can enable the log at runtime!

#general_log_file = /var/log/mysql/mysql.log

#general_log = 1

log_error = /usr/local/var/mysql/MacBook15.local.err

# Here you can see queries with especially long duration

#log_slow_queries = /var/log/mysql/mysql-slow.log

#long_query_time = 2

#log-queries-not-using-indexes

#

# The following can be used as easy to replay backup logs or

# for replication.

# note: if you are setting up a replication slave, see

# README.Debian about other settings you may need

# to change.

#server-id = 1

#log_bin = /var/log/mysql/mysql-bin.log

expire_logs_days = 10

max_binlog_size = 100M

#binlog_do_db = include_database_name

#binlog_ignore_db = include_database_name

#

# * InnoDB

#

# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.

# Read the manual for more InnoDB related options. There are many!

#

# * Security Features

#

# Read the manual, too, if you want chroot!

# chroot = /var/lib/mysql/

#

總結

以上是生活随笔為你收集整理的mac mysql 安装日志_Mac 安装 MySQL的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。