1 使用.dmg文件安装
2 运行MySQL
- 左上角点击苹果图标，system preference搜索mysql，就在最下方。
- 打开之后点start就可以了
- 详情件reference最后一个链接
3 下载GUI tool for MySQl
- mysql-workbench 是一个开源免费的gui tool for mysql.
- URL: https://dev.mysql.com/downloads/workbench/
- 新建一个instance连接MySQL: https://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial-create-connection.html
Note:
- 在
/Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist文件可以修改port - 注意
--port=3306，这个是默认的 - 查看 MySQL server process, 使用命令
sudo launchctl list|grep mysql.
Howes-MacBook-Pro:LaunchDaemons howezhao$ sudo launchctl list|grep mysql
13606 0 com.oracle.oss.mysql.mysqld
Trouble shooting
1 在命令行输入mysql，现实command not found， 可能是mysql的path没设置好
- 在命令行运行
export PATH=${PATH}:/usr/local/mysql/bin再试试 -
.bash_profile就在打开terminal时的根目录下，使用nano .bash_profile就可以打开, 在这个文件下添加以上命令行就可以每次打开terminal时自动运行export了。
com.oracle.oss.mysql.mysqld.plist
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>Label</key> <string>com.oracle.oss.mysql.mysqld</string>
<key>ProcessType</key> <string>Interactive</string>
<key>Disabled</key> <false/>
<key>RunAtLoad</key> <true/>
<key>KeepAlive</key> <true/>
<key>SessionCreate</key> <true/>
<key>LaunchOnlyOnce</key> <false/>
<key>UserName</key> <string>_mysql</string>
<key>GroupName</key> <string>_mysql</string>
<key>ExitTimeOut</key> <integer>600</integer>
<key>Program</key> <string>/usr/local/mysql/bin/mysqld</string>
<key>ProgramArguments</key>
<array>
<string>/usr/local/mysql/bin/mysqld</string>
<string>--user=_mysql</string>
<string>--basedir=/usr/local/mysql</string>
<string>--datadir=/usr/local/mysql/data</string>
<string>--plugin-dir=/usr/local/mysql/lib/plugin</string>
<string>--log-error=/usr/local/mysql/data/mysqld.local.err</string>
<string>--pid-file=/usr/local/mysql/data/mysqld.local.pid</string>
<string>--keyring-file-data=/usr/local/mysql/keyring/keyring</string>
<string>--early-plugin-load=keyring_file=keyring_file.so</string>
<string>--port=3306</string>
</array>
<key>WorkingDirectory</key> <string>/usr/local/mysql</string>
</dict>
</plist>
Reference:
https://dev.mysql.com/downloads/
https://dev.mysql.com/downloads/mysql/
https://dev.mysql.com/doc/refman/5.7/en/osx-installation.html
https://dev.mysql.com/doc/refman/5.5/en/osx-installation-pkg.html
https://dev.mysql.com/doc/refman/5.7/en/osx-installation-launchd.html
