mysql upgarde on mac osx 10.9

停止mysql服務

sudo /usr/local/mysql/support-files/mysql.server stop

到mysql官網抓取安裝程式
在此安裝了mysql 5.6.20

點選下載下來的.pkg檔案,安裝MySQL Server

確認/usr/local/mysql是否指定新版的sql

1.ls -al /usr/local/mysql

2.lrwxr-xr-x  1 root  wheel  27  8 24 23:36 /usr/local/mysql -> mysql-5.6.20-osx10.8-x86_64

將舊版本data複製到新版

1.cd /usr/local

2.sudo cp -rf mysql-5.5.27-osx10.6-x86_64/data/  mysql-5.6.20-osx10.8-x86_64/data/

3.確認權限是否正確，如果不對，利用sudo chown -R 更改權限

啟動新版本的MySQL

sudo /usr/local/mysql/support-files/mysql.server start

執行升級程序 

1.sudo /usr/local/mysql/bin/mysql_upgrade

2.sudo /usr/local/mysql/support-files/mysql.server restart 

更新密碼 

/usr/local/mysql/bin/mysqladmin -u root password 'password' 

Note:

官方說明文件