Myeclipse+mysql (i)

MyEclipse connecting MySQL Database

Preparation: MyEclipse is using version 2013, MySQL Ver 14.14 distrib 5.6.28

Download of 1.jar packages (JDBC driver)

I downloaded: Mysql-connector-java-5.1.7-bin.jar

2. Open myeclipse----> select window----> select Open perspecctive---->myeclipse Database Explorer will enter the following interface.

On the right side of the DB browser working interval there is a downward triangle, such as the direction of the red arrow pointing, click the drop-down box appears.

Go to new Database connection Driver---->

Driver template----> select MySQL connector/j

Driver name----> pick one (e.g. user)

Connection URL---->jdbc:mysql://localhost:3306/fuck (this URL needs to be noted, because MySQL is accessing the database on this computer, so set the 3306 port of localhost, The "Fuck" is the name of the database that I created in the MySQL database, and if you haven't built it yet, you should first set up a database and proceed to the next step. Otherwise, an error will occur. )

Continue above:

Username---->root (can be taken as long as you can remember)

Password---->************* (don't say much)

ADD JARS----> select the first step to download the saved JAR file path---->test Driver----> If successful, the following interface will appear---->OK---->finish

When you return to the DB browser page, a directory named user "Driver name" will be given.

Right-click on user and click Open Connection to see the list of all libraries in the MySQL database.

Myeclipse+mysql (i)