目录

Idea连接数据库MySql-Workbench

目录

Idea连接数据库(MySql Workbench)

1、首先,你要在mySql Workbench中创建数据库。以下为例:

数据库:school

表:students

数据?哦 随便写的 不要在意 哈哈哈。

https://img-blog.csdn.net/20170611204839366?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvam9rZXI4MDIzam9rZXI=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast

2、然后,打开Idea,见下图

打开数据库连接窗口有两种方式,详情看图哦。

https://img-blog.csdn.net/20170611205602606?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvam9rZXI4MDIzam9rZXI=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast

3、创建连接,与mySQL建立连接

看图说话哦

https://img-blog.csdn.net/20170611210744611?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvam9rZXI4MDIzam9rZXI=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast

https://img-blog.csdn.net/20170611210944707?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvam9rZXI4MDIzam9rZXI=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast

4、测试成功,则数据库连接成功,点击“确定”,完成连接,则显示以下内容,若不显示数据库列表,则连接失败。

https://img-blog.csdn.net/20170611211154286?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvam9rZXI4MDIzam9rZXI=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast

5、duang~,完成连接。(此步骤用来庆祝,可忽略不见,哈哈哈)。