OSX10.9 MYSQL5.6安装

安装分为 PKG包格式与DMG压缩格式，这里下载DMG方便省事。

1、下载并安装

 http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.20-osx10.8-x86_64.dmg

2、安装验证并启动服务

安装位置：

 <pre name="code" class="plain">fuyundeMacBook-Pro:Local fuyun$ pwd
/usr/Local
fuyundeMacBook-Pro:Local fuyun$ ls -al
total 8
drwxr-xr-x   6 root  wheel  204 Sep  7 15:05 .
drwxr-xr-x@ 12 root  wheel  408 Aug 31 23:55 ..
drwxr-xr-x  20 root  wheel  680 Jun 19 08:31 go
drwxr-xr-x   3 root  wheel  102 Aug 31 23:55 lib
lrwxr-xr-x   1 root  wheel   27 Sep  7 15:05 mysql -> mysql-5.6.20-osx10.8-x86_64
drwxr-xr-x  17 root  wheel  578 Sep  7 15:05 mysql-5.6.20-osx10.8-x86_64

服务启动项：

fuyundeMacBook-Pro:MySQLCOM fuyun$ ./MySQLCOM
Usage: ./MySQLCOM [start|stop|restart] 
sudo /Library/StartupItems/MySQLCOM/MySQLCOM start

 

也可以在‘系统偏好设置’如下图

 3、更改密码

fuyundeMacBook-Pro:Local fuyun$ /usr/local/mysql/bin/mysqladmin -u root password 12345678
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

/usr/local/mysql/bin/mysql -u root -p
use mysql;
UPDATE user SET Password=PASSWORD('123456') where USER='root';
重启服务并删除之前在my.cnf中添加的'skip_grant_tables'