本教程以Navicat为例，其他软件同理

#### 导入步骤
 1. 打开Navicat，新建连接，输入本地mysql的用户名和密码

![](https://img.yidaima.cn/b1f2cd6706eb4175b7ed28c9025f35aa?imageView2/0/q/75|watermark/2/text/ZmVhc3Rjb2RpbmcuY24=/font/5a6L5L2T/fontsize/1600/fill/IzBERDBGNQ==/dissolve/100/gravity/Center/dx/10/dy/10)

 2. 选择建立的连接，右键 -》新建数据库。数据库名是sql文件的名字，字符集选utf8mb4

![](https://img.yidaima.cn/10586004b3b646f0a3a24973d0b5aec4?imageView2/0/q/75|watermark/2/text/ZmVhc3Rjb2RpbmcuY24=/font/5a6L5L2T/fontsize/1600/fill/IzBERDBGNQ==/dissolve/100/gravity/Center/dx/10/dy/10)

![](https://img.yidaima.cn/90fed170dae74d00bc6e002486ce8158?imageView2/0/q/75|watermark/2/text/ZmVhc3Rjb2RpbmcuY24=/font/5a6L5L2T/fontsize/1600/fill/IzBERDBGNQ==/dissolve/100/gravity/Center/dx/10/dy/10)

 3. 打开数据库，右键 -》 运行SQL文件
 
![](https://img.yidaima.cn/30dcabfbd90b4a18bf9a417f5ac03a36?imageView2/0/q/75|watermark/2/text/ZmVhc3Rjb2RpbmcuY24=/font/5a6L5L2T/fontsize/1600/fill/IzBERDBGNQ==/dissolve/100/gravity/Center/dx/10/dy/10)

![](https://img.yidaima.cn/e0a5c6f7f6984310a98ca9b4ebf03020?imageView2/0/q/75|watermark/2/text/ZmVhc3Rjb2RpbmcuY24=/font/5a6L5L2T/fontsize/1600/fill/IzBERDBGNQ==/dissolve/100/gravity/Center/dx/10/dy/10)

 4. 导入完成，在左边空白处刷新就ok了

![](https://img.yidaima.cn/88e40580964f4b8f86ec40eec6393344?imageView2/0/q/75|watermark/2/text/ZmVhc3Rjb2RpbmcuY24=/font/5a6L5L2T/fontsize/1600/fill/IzBERDBGNQ==/dissolve/100/gravity/Center/dx/10/dy/10)