1. Download and install MySQL
1) to http://dev.mysql.com/downloads/download MySQL Community Edition Server, and the connector for JDBC. All the way to the default installation, it is important to remember the MySQL database username and password.
2) installed by default to C:\Program Files\mysql or C:\Program Files (x86) \mysql, the driver package required for the MyEclipse connection is under the MySQL Connector J folder in that folder, Called Mysql-connector-java-5.1.31-bin.jar.
2. Download and install Navicat
1) to http://www.navicat.com.cn/download download mysql version of Navicat, be able to try 30 days. can also download cracked version.
2) Open Navicat, click Connect, create a new connection, enter their own definition of the connection name, username and password is the installation of MySQL username and password, the other do not change, the last point to determine.
3) Double click on your new connection to open the connection and it will turn green. You can right-click a new database and enter a database name to determine it. Double-click the database to open it. You will then be able to create new tables and other operations.
3. Establish MySQL connection to MyEclipse
References http://jingyan.baidu.com/article/4e5b3e196758ad91901e24a0.html
The first step is to open database
Figure A
Open MyEclipse and click the Window form to click on the MyEclipse Database Explorer entry in the Open Perspective menu (Figure II)
Second step to create a connection
Figure II
Right-click the mouse in the blanks to create new (that is, new) or click on the shortcut key in the menu bar (the triangular symbol down in figure two) to create a new one. Pop up the database Driver menu See (Figure III)
The third step is to select the connection mode
Might
In the Driver Template option box, select MySQL connector/j as shown in Figure four
Fourth step fill in the configuration information
Figure Four
In
Driver name fill in the names of the linked database (this can be filled out by yourself, it is best to find out what the project name is related to when it is easy to use)
Connection URL used to fill in the connection to use the MySQL database address (jdbc:mysql://
User name fills in the database usernamemysql default is root
Password fill in the interview password you set up when you visit the MySQL database. For example, figure five
Figure Five
Fifth Step Add driver
Figure six
Click Add jars to join MyEclipse to connect to the MySQL database driver file (the file is best to store the driver files in English folder, in the test to determine that the MySQL database is open, or test will not succeed), Here is the Mysql-connector-java-5.1.7-bin version number (able to search the Web for download,) as shown in Figure seven
Sixth step test data configuration is correct
Figure Seven
Click Test driver to see if the configuration was successful and enter the database password. For example, figure eight
Figure Eight
Seventh Step Test success
Figure Nine
Test connect MySQL database successfully, click Finish to create the connection.
Eighth on-foot connection database
Figure 10
Right click on the connection you created click Open another connection enter MySQL database password you can see the database table you created. As shown in Figure 11, Figure 12
Figure 11
Figure 12
Install MySQL and navicat, and connect with MyEclipse