Mac安装Mysql及错误处理

下载安装包

官方下载地址：MySQL

如何在官方地址找到适合自己的下载源：

• 首页找到DOWNLOADS

• 下载页找到MySQL Community (GPL) Downloads »，这个就是开源免费的版本

  MySQL Enterprise Edition 、MySQL Cluster CGE是收费版本不选

• MySQL Community Downloads页面找到Download Archives=>MySQL Community Server找到对应版本选择dmg下载即可

  MySQL Community Downloads页面找到MySQL Community Server可以直接下载最新的mysql版本一般为8.xx

• 一般下载5.3几版本，我用的5.3.1

安装mysql

• 打开mysql-5.7.31-macos10.14-x86_64.dmg

  

• 继续安装->同意许可=>输入密码或者录入指纹授权安装

​

配置Mysql

• 查看安装的mysql目录

  • 通过访达的前往文件夹查看=>输入/usr/local/

    

  • 通过命令行查看：cd /usr/local/mysql ls -la查看目录详情

• 设置环境变量

  1. 编辑~/.zshrc或者~/.zprofile

  2. 我是编辑的~/.zshrc，了解了下目前的mac都是用此配置文件，增加以下内容

     vim ~/.zshrc以下是我的配置文件

     source ~/.bash_profile
     export ANDROID_HOME=$HOME/Library/Android/sdk
     export PATH=$PATH:$ANDROID_HOME/emulator
     export PATH=$PATH:$ANDROID_HOME/tools
     export PATH=$PATH:$ANDROID_HOME/tools/bin
     export PATH=$PATH:$ANDROID_HOME/platform-tools
     
     #flutter环境变量
     export PATH=/Users/thell/flutter/bin:$PATH
     
     #mysql环境配置
     export PATH=$PATH:/usr/local/mysql/bin
     export PATH=$PATH:/usr/local/mysql
     export PATH=$PATH:/usr/local/mysql/support-files
     
     "~/.zshrc" 14L, 445B
     

  3. 让配置文件生效source ~/.zshrc,就可以使用mysql mysqld加命令，不用带/usr/local/mysql前缀

• 设置配置文件：新建/usr/local/mysql/etc/my.cnf，增加以下内容：

  [mysqld]
  
  port=3306
  
  basedir=/usr/local/mysql
  
  datadir=/usr/local/mysql/data
  

• 启动mysql服务报错处理：

  $ mysql.server start
  Starting MySQL
  . ERROR! The server quit without updating PID file (/usr/local/mysql/data/jh.local.pid).
  $ mysql.server status
  /usr/local/mysql/support-files/mysql.server: line 365: pidof: command not found
   ERROR! MySQL is not running
  

• Starting MySQL
   SUCCESS!
  thell@hailongdeMacBook-Air mysql % /usr/local/mysql/bin/mysqld_safe: line 144: /usr/local/mysql/data/hailongdeMacBook-Air.local.err: Permission denied
  cat: /usr/local/mysql/data/hailongdeMacBook-Air.local.pid: Permission denied
  rm: /tmp/mysql.sock: Permission denied
  /usr/local/mysql/bin/mysqld_safe: line 144: /usr/local/mysql/data/hailongdeMacBook-Air.local.err: Permission denied
  /usr/local/mysql/bin/mysqld_safe: line 198: /usr/local/mysql/data/hailongdeMacBook-Air.local.err: Permission denied
  /usr/local/mysql/bin/mysqld_safe: line 144: /usr/local/mysql/data/hailongdeMacBook-Air.local.err: Permission denied
  

• 因为mac系统启动自动启动了mysql,查看是否启动了mysql命令：ps -ef | grep mysql

  

• 查案启动文件是否存在：cd /Library/LaunchDaemons ls可查看到com.oracle.oss.mysql.mysqld.plist

  

• 卸载系统自动启动：sudo launchctl unload -w /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

  • 详细说明参考：MySQL 启动报错问题排查 - 知乎 (zhihu.com)

• 删除mysql的进程：ps -ef | grep mysql找到相应的进程id，kill -9 id号全部删除掉

• mysql目录下的data下的日志文件要有读写权限sudo chmod -R a+rwx /usr/local/mysql/data/hailongdeMacBook-Air.local.err

Starting MySQL
./usr/local/mysql/bin/mysqld_safe: line 144: /usr/local/mysql/data/hailongdeMacBook-Air.local.err: Permission denied
/usr/local/mysql/bin/mysqld_safe: line 144: /usr/local/mysql/data/hailongdeMacBook-Air.local.err: Permission denied
/usr/local/mysql/bin/mysqld_safe: line 198: /usr/local/mysql/data/hailongdeMacBook-Air.local.err: Permission denied
/usr/local/mysql/bin/mysqld_safe: line 144: /usr/local/mysql/data/hailongdeMacBook-Air.local.err: Permission denied
 ERROR! The server quit without updating PID file (/usr/local/mysql/data/hailongdeMacBook-Air.local.pid).

• mysql目录下的data用户组的是mysql不能为_mysql,执行命令:sudo chown -R mysql:mysql /usr/local/mysql/data/*

thell@hailongdeMacBook-Air LaunchDaemons % mysql.server start
Starting MySQL
.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/hailongdeMacBook-Air.local.pid)

• 以上全部更改后,执行sudo mysql.server start,启动成功，不用sudo会提示权限不够