Mac下安装MySQL、Workbench以及建数据库建表最基础操作
初学者在Mac下安装MySQL、Workbench以及建数据库建表最基础操作
首先,到官网下载安装包,下载过程中需要oracle账号。自己注册一个或者找别人借用,http://www.jb51.net/softs/451120.html
或者http://pan.baidu.com/s/1bpfCI8R,我的百度网盘
先下载mysql安装包
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620144744163-2128897490.png)
点击download下载
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620144840882-1359566801.png)
选择DMG的,download
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620144857054-256003850.png)
会自动识别你的Mac版本,download
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620144916320-1598921566.png)
双击下载完成后的安装包,下一步...
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145110413-2059938847.png)
安装完成后,会弹窗,有个默认密码,我这个是:A5a:RthiC-z8,建议截图保存
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145121273-72214355.png)
没保存也没事,通知栏里面有
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145153695-1069498214.png)
这时,打开系统偏好设置你会发现已经有了mysql了,恭喜你,双击
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145213976-846915147.png)
点击start开启数据库
这时候,你就可以使用数据库了,你可以再下载一个MySQL Workbench或者navicat来更方便的管理数据库,因为我之前就已经安装了navicat,一直在用,太熟悉了,所以想折腾一下MySQL Workbench,毕竟以前没有用过,下面是下载安装MySQL Workbench的过程
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145441601-711483746.png)
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145523070-1472527877.png)
download
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145542648-1977378247.png)
安装
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145600241-2111285847.png)
安装完成后,输入默认密码
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145621413-1562949593.png)
修改密码,此处我修改为root,做个记录,免得自己忘了
mysql Workbench建库建表
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145714726-972070598.png)
点击
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145731195-1461498472.png)
输入数据库名,Apply
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145750570-1452472225.png)
Apply
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145817335-996196019.png)
close
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145837070-1270795371.png)
SCHEMAS里面此时可以看到刚刚创建的数据库
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145857851-869387302.png)
Create Table
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145913491-1148231615.png)
填写表名、字段等信息,Apply-Apply-close
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145930288-1483569303.png)
Select Rows - Limit 1000
![](https://images2015.cnblogs.com/blog/868663/201706/868663-20170620145946616-2020104868.png)
创建数据,OK,最基础的建库建表操作已完
新浪微博:陶杰童鞋
posted on 2017-06-20 15:01 TAOJIETX 阅读(10823) 评论(0) 编辑 收藏 举报