执行:
brew install mysql
等成功安装完成,结果想要登录的时候报了个错误:
ERROR 2002 (HY000): Can not connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
网上搜索了半天,找到解决方案,依次执行
unset TMPDIR
“`bash mysql_install_db –verbose –user=root –basedir=”$(brew –prefix mysql)”–datadir=/usr/local/var/mysql –tmpdir=/tmp
接下来启动mysql
“`bash
mysql.server start
启动后就可以登录了,登录命令为:
mysql -uroot -p
然后提示输入数据库密码,初始没有密码的情况下直接回车,就进入数据库了
如果想设置开机启动,执行下面的命令
mkdir -p ~/Library/LaunchAgents
cp /usr/local/Cellar/mysql/5.6.16/homebrew.mxcl.mysql.plist ~/Library/LaunchAgents/ #5.6.16是数据库版本号,根据你当时所安装的版本号自己修改
launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
大功告成~