mac 上mysql 安装

男娘i 2022-06-08 07:20 162阅读 0赞

转载自：http://www.cnblogs.com/chenmo-xpw/p/6102933.html

Mac 安装MySQL有两种方式。下面一一介绍

一、下载dmg包安装

1、下载MySQL dmg 包, 从官网 : [http://www.mysql.com/downloads/][http_www.mysql.com_downloads] 进入, 点击下方的DOWNLOADS : MySQL Community Server

![613452-20161126165929456-2095196460.png][]

选择dmg文件下载

![613452-20161126170215706-217180770.png][]

接着, 会跳转到如下页面, 你只需要选择不登录,直接下载即可　　![613452-20161126170027190-1129946601.png][]

2、进入系统偏好设置,点击MySQL,开启MySQL服务

3、环境变量配置（windows也是这样run的。可以不配置, 但每次必须在msyql的安装目录下,执行mysql命令。）

进入到用户目录下 执行 vim .bash\_profile   。添加如下内容

##mysql
    export PATH=${PATH}:/usr/local/mysql/bin

快速启动、结束MySQL服务, 可以使用alias命令

alias mysqlstart='sudo /usr/local/mysql/support-files/mysql.server start'
    alias mysqlstop='sudo /usr/local/mysql/support-files/mysql.server stop'

我们就可以在任何地方执行mysql命令了。

如果你还没有配置环境变量, 可以先进入MySQL安装目录, 再执行MySQL相关命令。安装目录在/user/local/mysql版本 。 我的目录是

/usr/local/mysql-5.7.16-osx10.11-x86_64

遇到的问题顺便在这里提下, 说不定能帮读者少走点弯路, 参考资料 http://stackoverflow.com/questions/13480170/access-denied-for-mysql-error-1045

在终端直接输入 Mysql -uroot -p , 弹出输入密码, 输入密码后就报如下错误

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

如果输入 mysql -uroot , 会显示另外一种错误

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

google了下, 找到了几个解决方案

方案一 （以非授权模式启动, 这样可以不输入密码）：

①、先把MySQL服务关了

<table style="border-collapse:collapse; border-spacing:0px; word-break:break-word; margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:100%!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; font-size:12px!important; min-height:inherit!important"> 
 <tbody style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important"> 
  <tr style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important"> 
   <td style="border-collapse:collapse; margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:35px!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important; color:rgb(175,175,175)!important"> 
    <div style="margin:0px!important; padding:0px 0.5em!important; background-color:rgb(244,244,244)!important; border-width:0px 2px 0px 0px!important; border-right-style:solid!important; border-right-color:rgb(108,226,108)!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; text-align:right!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important; white-space:nowrap!important">
      1 
    </div> </td> 
   <td style="border-collapse:collapse; margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important"> 
    <div style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:relative!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important"> 
     <div style="margin:0px!important; padding:0px 1em!important; background-color:rgb(244,244,244)!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important; white-space:nowrap!important"> 
      <code style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important">msyqlstop</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

②、在终端输入

sudo mysqld_safe --skip-grant-tables

③、新开另一个终端

直接输入 mysql

④、修改下mysql默认密码

注意 ： mysql 5.7 密码字段是字段 authentication\_string, 而不是之前版本的 password 参考资料 http://bbs.bestsdk.com/detail/762.html

UPDATE user SET authentication_string=PASSWORD('root') WHERE user = 'root'

密码修改可以参考下这篇博文 ：http://zhouxuguang.blog.51cto.com/1053090/236292

方案二（授权模式启动,需要输入登录安装MySQL默认生成的密码）：

①、进入到安装目录,

<table style="border-collapse:collapse; border-spacing:0px; word-break:break-word; margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:100%!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; font-size:12px!important; min-height:inherit!important"> 
 <tbody style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important"> 
  <tr style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important"> 
   <td style="border-collapse:collapse; margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:35px!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important; color:rgb(175,175,175)!important"> 
    <div style="margin:0px!important; padding:0px 0.5em!important; background-color:rgb(244,244,244)!important; border-width:0px 2px 0px 0px!important; border-right-style:solid!important; border-right-color:rgb(108,226,108)!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; text-align:right!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important; white-space:nowrap!important">
      1 
    </div> </td> 
   <td style="border-collapse:collapse; margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important"> 
    <div style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:relative!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important"> 
     <div style="margin:0px!important; padding:0px 1em!important; background-color:rgb(244,244,244)!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important; white-space:nowrap!important"> 
      <code style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important">cd /usr/local/mysql/bin</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

执行

<table style="border-collapse:collapse; border-spacing:0px; word-break:break-word; margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:100%!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; font-size:12px!important; min-height:inherit!important"> 
 <tbody style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important"> 
  <tr style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important"> 
   <td style="border-collapse:collapse; margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:35px!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important; color:rgb(175,175,175)!important"> 
    <div style="margin:0px!important; padding:0px 0.5em!important; background-color:rgb(244,244,244)!important; border-width:0px 2px 0px 0px!important; border-right-style:solid!important; border-right-color:rgb(108,226,108)!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; text-align:right!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important; white-space:nowrap!important">
      1 
    </div> </td> 
   <td style="border-collapse:collapse; margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important"> 
    <div style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:relative!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important"> 
     <div style="margin:0px!important; padding:0px 1em!important; background-color:rgb(244,244,244)!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important; white-space:nowrap!important"> 
      <code style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important">mysql -uroot -p</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

![613452-20170624115601007-74959114.png][]

再执行 show databases; 提示重置密码。

重置密码

<table style="border-collapse:collapse; border-spacing:0px; word-break:break-word; margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:100%!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; font-size:12px!important; min-height:inherit!important"> 
 <tbody style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important"> 
  <tr style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important"> 
   <td style="border-collapse:collapse; margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:35px!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important; color:rgb(175,175,175)!important"> 
    <div style="margin:0px!important; padding:0px 0.5em!important; background-color:rgb(244,244,244)!important; border-width:0px 2px 0px 0px!important; border-right-style:solid!important; border-right-color:rgb(108,226,108)!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; text-align:right!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important; white-space:nowrap!important">
      1 
    </div> </td> 
   <td style="border-collapse:collapse; margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important"> 
    <div style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:relative!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important"> 
     <div style="margin:0px!important; padding:0px 1em!important; background-color:rgb(244,244,244)!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; min-height:inherit!important; white-space:nowrap!important"> 
      <code style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important">SET PASSWORD = PASSWORD(</code> 
      <code style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important; color:blue!important">'root'</code> 
      <code style="margin:0px!important; padding:0px!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important">);</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

![613452-20170624115809570-1237620194.png][]

参考  https://stackoverflow.com/questions/33467337/reset-mysql-root-password-using-alter-user-statement-after-install-on-mac

4、下载安装MySQL Workbench(GUI Tool)

访问[http://www.mysql.com/downloads/][http_www.mysql.com_downloads] 在下面有一个MySQL Workbench(GUI Tool)的项，点击其下的DOWNLOAD即可进入下载界面：

环境变量配置（这个不难理解, 像window系统一样,需要配置环境变量,Mysql命令才能被系统识别）

二、使用homebrew安装MySQL（推荐）

1、安装命令

brew install mysql

2、启动MySQL

bash mysql.server start

3、mysql -uroot 登录

![613452-20161125204330300-751404305.png][]

参考文献

[http://www.cnblogs.com/macro-cheng/archive/2011/10/25/mysql-001.html][http_www.cnblogs.com_macro-cheng_archive_2011_10_25_mysql-001.html]

[http_www.mysql.com_downloads]: http://www.mysql.com/downloads/
[613452-20161126165929456-2095196460.png]: /images/20220608/9f6d630244a9487794276b63f938980a.png
[613452-20161126170215706-217180770.png]: /images/20220608/11d5d6c58f6a4033a4d4094af0c49758.png
[613452-20161126170027190-1129946601.png]: /images/20220608/3baef5f334fc406e9638b3ca5bc23234.png
[613452-20170624115601007-74959114.png]: /images/20220608/1134e272ef694d7f9c4130891402ff2a.png
[613452-20170624115809570-1237620194.png]: /images/20220608/2dd9eb4a6a284393b454213967f16678.png
[613452-20161125204330300-751404305.png]: /images/20220608/590c6126b5c24abfb44afe525c8a2bb7.png
[http_www.cnblogs.com_macro-cheng_archive_2011_10_25_mysql-001.html]: http://www.cnblogs.com/macro-cheng/archive/2011/10/25/mysql-001.html