删除mysql
- 左上角“系统偏好设置”,打开MySQL面板,停止MySQL服务
- 在文件“/etc/hostconfig”中删除一行“MYSQLCOM=-YES-”
- 分别执行以下命令:
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
sudo rm -rf ~/Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /var/db/receipts/com.mysql.*
这时,重新进去“系统偏好设置”,就会发现MySQL面板已经不见了。
安装mysql(方法1: homebrow)
brew install mysql@5.7
如果想要最新的版本,使用命令:brew install mysql
如果发生以下错误,可以这么处理:
MD314:~ rudon$ brew install mysql@5.7
Updating Homebrew...
Error: mysql@5.7: Calling `sha256 "digest" => :tag` in a bottle block is disabled! Use `brew style --fix` on the formula to update the style or use `sha256 tag: "digest"` instead.
Please report this issue to the homebrew/core tap (not Homebrew/brew or Homebrew/core), or even better, submit a PR to fix it:
/usr/local/Homebrew/Library/Taps/homebrew/homebrew-core/Formula/mysql@5.7.rb:8
MD314:~ rudon$ brew style --fix
安装mysql(方法2: 官网)
https://downloads.mysql.com/archives/community/
选择mysql版本5,再选择平台;
下载+鼠标安装
ok
修改mysql用户权限
创建用户
create user 'name-of-user'@'%' identified by 'password-of-user';
授权用户
grant all privileges on *.* to 'name-of-user'@'%';
flush privileges;
或者
grant all privileges on oneDbName.oneTableName to 'name-of-user'@'%';
flush privileges;