Mac下brew安装mysql

男德
2,423 阅读2分钟

安装homebrew

直接去官网看教程

或者执行下方命令安装(官网copy过来的

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

安装mysql

  • 搜索mysql相关
brew search mysql

==> Formulae
automysqlbackup          mysql++                  mysql-client@5.7         mysql-sandbox            mysql@5.6                mysqltuner
mysql                    mysql-client             mysql-connector-c++      mysql-search-replace     mysql@5.7 
==> Casks
mysql-connector-python   mysql-shell              mysql-utilities          mysqlworkbench           navicat-for-mysql        sqlpro-for-mysql
  • 这里选择安装5.7版本
brew install mysql@5.7
  • 安装后添加环境变量 并应用生效
echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> ~/.zshrc

source ~/.zshrc

设置mysql密码

安装完成设置完环境变量 来设置密码 执行下边的命令

mysql_secure_installation

如果出现报错之类的 可能是没有启动mysql

# 启动mysql
mysql.server start

然后再运行mysql_secure_installation

会出现命令选择

  • 第一个 这个是选择是否开启校验密码强度插件(应该是这样
➜  bin ./mysql_secure_installation

Securing the MySQL server deployment.

Connecting to MySQL using a blank password.

VALIDATE PASSWORD PLUGIN can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD plugin?
  • 第二个 设置mysql密码
  • 第三个 再次输入密码
  • 第四个 说默认有个账户是否删除他 (删除y 否则 n
  • 第无个 是否允许远程连接
  • 第六个 默认有个test库是否删除他
  • 第七个 是否确认更改是这次所有更改生效 Y ok
Success.

All done!

如何启动等

# 启动
brew services run mysql
brew services start mysql
# 停止
brew services stop mysql
# 重启
brew services restart mysql

brew services 常用命令

brew services list  # 查看使用brew安装的服务列表
brew services run formula|--all  # 启动服务（仅启动不注册）
brew services start formula|--all  # 启动服务，并注册
brew services stop formula|--all   # 停止服务，并取消注册
brew services restart formula|--all  # 重启服务，并注册
brew services cleanup  # 清除已卸载应用的无用的配置

完全删除mysql(mac下）

复制于这里

ps -ax | grep mysql
# stop and kill any MySQL processes
brew remove mysql
brew cleanup
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/var/mysql
sudo rm -rf /usr/local/mysql*
sudo rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
# 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*
# restart your computer just to ensure any MySQL processes are killed
# try to run mysql, it shouldn't work

到这里是正常情况就结束了。

可能过程中有一些问题

  • 在启动时保存无法启动 尝试加上sudo
  • sudo还不行的话可能是mysql对一些文件夹没有权限，尝试以下命令
sudo chown -R _mysql /usr/local/var/mysql
sudo chmod -R o+rwx /usr/local/var/mysql
avatar
文章
阅读
粉丝