mac安装个mysql着实让人闹心，鼓捣了好长时间就是安不上，在网上各种找解决方案就是不行，最后终于解决了，留个备案。
安装步骤
brew update
brew install mysql
unset TMPDIR
mkdir /usr/local/var
以上步骤一般情况是不会出问题的,当执行mysql.server start 时就会报错
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
就是这个怎么都无法解决，网上说执行
mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp可以解决，但是同样报错
帖解决方案；
cp /usr/local/Cellar/mysql/5.6.10/homebrew.mxcl.mysql.plist ~/Library/LaunchAgents/ 加这个就可以解决
2 添加配置
[mysqld] port = 3306 socket = /tmp/mysql.sock skip-external-locking key_buffer_size = 16K pid-file=/usr/local/var/mysql/mysqld.pid [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/usr/local/var/mysql/mysqld.pid
3 修改权限
sudo chown -R _mysql /usr/local/var/mysql
4 修改root的密码
update mysql.user set authentication_string=password('xxx') where user='root' and Host = 'localhost';
flush privileges;
参考地址：
https://mba811.gitbooks.io/mac-dev/content/MySql/index.html
https://easyengine.io/tutorials/mac/osx-brew-php-mysql-nginx/
