![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRRM05EUXhOak10TWpFeU9EZzVOelE1TUM1d2JtYz0%3D.jpg?w=700&webp=1)
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRRNE5EQTRPREl0TVRNMU9UVTJOamd3TVM1d2JtYz0%3D.jpg?w=700&webp=1)
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRRNE5UY3dOVFF0TWpVMk1EQXpPRFV3TG5CdVp3PT0%3D.jpg?w=700&webp=1)
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRRNU1UWXpNakF0TVRVNU9Ea3lNVFUyTmk1d2JtYz0%3D.jpg?w=700&webp=1)
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVeE1UQTBNVE10TWpBMU9Ua3pPRGcwTnk1d2JtYz0%3D.jpg?w=700&webp=1)
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVeE1qRXlOek10TnpJeU1UUXpOVFV1Y0c1bg%3D%3D.jpg?w=700&webp=1)
没保存也没事,通知栏里面有
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVeE5UTTJPVFV0TVRBMk9UUTVPREl4TkM1d2JtYz0%3D.jpg?w=700&webp=1)
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVeU1UTTVOell0T0RRMk9URTFNVFEzTG5CdVp3PT0%3D.jpg?w=700&webp=1)
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVME5ERTJNREV0TnpFeE5EZ3pOelEyTG5CdVp3PT0%3D.jpg?w=700&webp=1)
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVMU1qTXdOekF0TVRRM01qVXlOemczTnk1d2JtYz0%3D.jpg?w=700&webp=1)
download
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVMU5ESTJORGd0TVRrM056TTNPREkwTnk1d2JtYz0%3D.jpg?w=700&webp=1)
安装
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVMk1EQXlOREV0TWpFeE1USTROVGcwTnk1d2JtYz0%3D.jpg?w=700&webp=1)
安装完成后,输入默认密码
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVMk1qRTBNVE10TVRVMk1qazBPVFU1TXk1d2JtYz0%3D.jpg?w=700&webp=1)
修改密码,此处我修改为root,做个记录,免得自己忘了
mysql Workbench建库建表![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVM01UUTNNall0T1RjeU1EY3dOVGs0TG5CdVp3PT0%3D.jpg?w=700&webp=1)
点击
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVM016RXhPVFV0TVRRMk1UUTVPRFEzTWk1d2JtYz0%3D.jpg?w=700&webp=1)
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVM05UQTFOekF0TVRRMU1qUTNNakl5TlM1d2JtYz0%3D.jpg?w=700&webp=1)
Apply
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVNE1UY3pNelV0T1RrMk1UazJNREU1TG5CdVp3PT0%3D.jpg?w=700&webp=1)
close
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVNE16Y3dOekF0TVRJM01EYzVOVE0zTVM1d2JtYz0%3D.jpg?w=700&webp=1)
SCHEMAS里面此时可以看到刚刚创建的数据库
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVNE5UYzROVEV0T0RZNU16ZzNNekF5TG5CdVp3PT0%3D.jpg?w=700&webp=1)
Create Table
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVNU1UTTBPVEV0TVRFME9ESXpNVFl4TlM1d2JtYz0%3D.jpg?w=700&webp=1)
填写表名、字段等信息,Apply-Apply-close
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVNU16QXlPRGd0TVRRNE16VTJPVE13TXk1d2JtYz0%3D.jpg?w=700&webp=1)
Select Rows - Limit 1000
![Mac下安装MySQL、Workbench以及建数据库建表最基础操作 Mac下安装MySQL、Workbench以及建数据库建表最基础操作](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9nby9hSFIwY0hNNkx5OXBiV0ZuWlhNeU1ERTFMbU51WW14dlozTXVZMjl0TDJKc2IyY3ZPRFk0TmpZekx6SXdNVGN3Tmk4NE5qZzJOak10TWpBeE56QTJNakF4TkRVNU5EWTJNVFl0TWpBeU1ERXdORGcyT0M1d2JtYz0%3D.jpg?w=700&webp=1)
创建数据,OK,最基础的建库建表操作已完
没保存也没事,通知栏里面有
download
安装
安装完成后,输入默认密码
修改密码,此处我修改为root,做个记录,免得自己忘了
mysql Workbench建库建表点击
Apply
close
SCHEMAS里面此时可以看到刚刚创建的数据库
Create Table
填写表名、字段等信息,Apply-Apply-close
Select Rows - Limit 1000
创建数据,OK,最基础的建库建表操作已完