Mysql（Navicat for Mysql）怎么添加数据库

分手后的思念是犯贱 2024-04-19 11:31 59阅读 0赞

# [Mysql（Navicat for Mysql）怎么添加数据库][Mysql_Navicat for Mysql] #

1、首先打开Navicat for Mysql；

![format_png][]

2、打开后界面如下图所示，双击连接localhost\_3306；

![format_png 1][]

3、连接后localhost\_3306变成绿色，如下图所示；

![format_png 2][]

4、选中下面任意数据库，单击鼠标右键，选择新建数据库；

![format_png 3][]

5、弹出新建数据库，输入数据库名，选择字符集gbk（不过我试过default 、gb2312、ascii都没出现问题），点击【确定】按钮；

![format_png 4][]

6、双击打开新建的数据库，选择该数据库，单击鼠标右键，选择菜单 运行SQL文件；

![format_png 5][]

7、在弹出窗口中选择文件，找到需要添加的sql文件，点击【开始】按钮开始执行；

![format_png 6][]

8、在添加数据库；

![format_png 7][]

9、添加完成点击【关闭】按钮，这个时候看到左侧“表”并没有显示刚刚添加的数据库表格，这个时候去把数据库关掉重新打开就能看到了。

![format_png 8][]

![format_png 9][]

标签: [MySQL][]

[Mysql_Navicat for Mysql]: https://www.cnblogs.com/wxh04/p/7831485.html
[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvNjk3ODE2LzIwMTcxMS82OTc4MTYtMjAxNzExMTQxMDU4MTIwNzctMTMwMTM5Mzk1MC5wbmc?x-oss-process=image/format,png
[format_png 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvNjk3ODE2LzIwMTcxMS82OTc4MTYtMjAxNzExMTQxMDU5MDA1MTUtODU3MjkyNDgucG5n?x-oss-process=image/format,png
[format_png 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvNjk3ODE2LzIwMTcxMS82OTc4MTYtMjAxNzExMTQxMDU5MzY5MzctMTYxOTA4MTY1OC5wbmc?x-oss-process=image/format,png
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvNjk3ODE2LzIwMTcxMS82OTc4MTYtMjAxNzExMTQxMTAwNDk2MjQtMjEwMzg0OTY5Ny5wbmc?x-oss-process=image/format,png
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvNjk3ODE2LzIwMTcxMS82OTc4MTYtMjAxNzExMTQxMTAxNTQ3MDItMTUyMjQyMjg5Mi5wbmc?x-oss-process=image/format,png
[format_png 5]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvNjk3ODE2LzIwMTcxMS82OTc4MTYtMjAxNzExMTQxMTA0MjM1NjItMjEwOTk0NTE0NC5wbmc?x-oss-process=image/format,png
[format_png 6]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvNjk3ODE2LzIwMTcxMS82OTc4MTYtMjAxNzExMTQxMTA1MjUwOTMtNzkyNDUyNzg1LnBuZw?x-oss-process=image/format,png
[format_png 7]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvNjk3ODE2LzIwMTcxMS82OTc4MTYtMjAxNzExMTQxMTA2MTYyODEtOTgwNTE2NTk3LnBuZw?x-oss-process=image/format,png
[format_png 8]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvNjk3ODE2LzIwMTcxMS82OTc4MTYtMjAxNzExMTQxMTA2NTAyMDItNzE3Njg3NzM2LnBuZw?x-oss-process=image/format,png
[format_png 9]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvNjk3ODE2LzIwMTcxMS82OTc4MTYtMjAxNzExMTQxMTA4MTE5MDYtOTcxOTIzMDY5LnBuZw?x-oss-process=image/format,png
[MySQL]: https://www.cnblogs.com/wxh04/tag/MySQL/