mac-osx安装mysql   2016-07-19


使用search查找mysql

1
2
3
4
5
brew search mysql 
automysqlbackup               mysql                         mysql-connector-c             mysql-search-replace
homebrew/versions/mysql55     mysql++                       mysql-connector-c++           mysqltuner
homebrew/versions/mysql56     mysql-cluster                 mysql-sandbox
homebrew/php/php53-mysqlnd_ms                               homebrew/php/php54-mysqlnd_ms                               homebrew/php/php55-mysqlnd_ms                               homebrew/php/php56-mysqlnd_ms

想要安装5.6版本，所以使用如下语句：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
brew install homebrew/versions/mysql56 
==> Installing mysql56 from homebrew/versions
==> Downloading https://homebrew.bintray.com/bottles-versions/mysql56-5.6.31.el_capitan.bottle.tar.gz
Already downloaded: /Users/ruifengshan/Library/Caches/Homebrew/mysql56-5.6.31.el_capitan.bottle.tar.gz
==> Pouring mysql56-5.6.31.el_capitan.bottle.tar.gz
==> /usr/local/Cellar/mysql56/5.6.31/bin/mysql_install_db --verbose --user=ruifengshan --basedir=/usr/local/Cellar/mysql56/5.6.31 --datadir=/usr/local/var/mysql --tmpdir=/tmp
==> 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 homebrew/versions/mysql56 now and restart at login:
  brew services start homebrew/versions/mysql56
Or, if you don't want/need a background service you can just run:
  /usr/local/opt/mysql56/bin/mysql.server start
==> Summary
  /usr/local/Cellar/mysql56/5.6.31: 9,979 files, 313.7M

此时需要按提示启动mysql(在后台运行服务):

1
brew services start homebrew/versions/mysql56

如果不想在后台运行服务，使用下面语句启动：

1
/usr/local/opt/mysql56/bin/mysql.server start

安装好默认是没有密码的，使用下面命令就可以进入mysql：

1
mysql -uroot

更改root密码：
进入mysql命令行，执行如下语句

1
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('shan');

遇到的问题：

之前因为一些原因安装又卸载过：

1
brew uninstall homebrew/versions/mysql56

结果连接的时候报了异常：

1
2
mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

网上查了一堆，发现也没有效果。发现之前的数据仍然保存在/usr/local/var/mysql,于是删除它，重新安装：

1
2
3
4
brew services stop homebrew/versions/mysql56
brew uninstall homebrew/versions/mysql56
sudo rm -rf /usr/local/var/mysql
brew install homebrew/versions/mysql56

就可以了。


分享到:


  如果您觉得这篇文章对您的学习很有帮助, 请您也分享它, 让它能再次帮助到更多的需要学习的人. 您的支持将鼓励我继续创作 !
本文基于署名4.0国际许可协议发布，转载请保留本文署名和文章链接。 如您有任何授权方面的协商，请邮件联系我。