install mysql for mac

mysql 官网http://dev.mysql.com/downloads/mysql/

下载 mysql-5.7.12-osx10.11-x86_64.dmg

安装 mysql-5.7.12-osx10.11-x86_64.pkg



mac下的默认安装路径/usr/local/mysql/bin

初次安装会分配一个随机密码给root用户(会有提示, root@local:之后的才是root密码)

安装完成后，在系统偏好设置里面,点击mysql图标，启动mysql服务


登录
{{{class="brush: shell"
cd /usr/local/mysql/bin
./mysql -u root -p

Enerpasswd: 此处输入root随机密码

}}}


修改密码
{{{class="brush: shell"

mysql>  SET PASSWORD = PASSWORD('louis866549');

}}}

如果没有随机密码：uninstall mysql，再重新安装mysql-5.7.12-osx10.11-x86_64.pkg

• Stop the database server
• sudo rm /usr/local/mysql
• sudo rm -rf /usr/local/mysql*
• sudo rm -rf /Library/StartupItems/MySQLCOM
• sudo rm -rf /Library/PreferencePanes/My*
• edit /etc/hostconfig and remove the line MYSQLCOM=-YES-
• rm -rf ~/Library/PreferencePanes/My*
• sudo rm -rf /Library/Receipts/mysql*
• sudo rm -rf /Library/Receipts/MySQL*
• sudo rm -rf /private/var/db/receipts/*mysql*