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 user name and password.
2) default installation to C:\Program Files\mysql or C:\Program Files (x86) \mysql, the driver package required to connect with MyEclipse in the directory of MySQL Connector J directory, 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, you can try 30 days. You can also download the cracked version.
2) Open Navicat, click Connect, create a new connection, enter a custom connection name, user name and password is the installation of MySQL user name and password, the other do not have to modify, 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. Double-click the database to open it. You can then create new tables and other operations.
3. Establish MySQL connection to MyEclipse
Reference http://jingyan.baidu.com/article/4e5b3e196758ad91901e24a0.html
The first step is to open database
Figure A
Open the MyEclipse and click the Windows window to enter the MyEclipse Database Explorer 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). 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 fill in database username MySQL default is root
Password fill in the access password you set when accessing the MySQL database. For example, figure five
Figure Five
Fifth Step Add driver
Figure six
Click Add Jars myeclipse connect to the MySQL database driver file (the best place to store the driver files is the English directory, when testing to determine that the MySQL database is open, otherwise the test will not succeed), Added here is the Mysql-connector-java-5.1.7-bin version (can be searched online download,) such as, figure seven
Sixth step test data configuration is correct
Figure Seven
Click Test driver to verify that the configuration was successful and enter the password to access the database. For example, figure eight
Figure Eight
Seventh Step Test success
Figure Nine
Test connect MySQL database successfully, click Finish to finish creating the connection.
Eighth on-foot connection database
Figure 10
Right click on the connection you created click Open another connection enter the MySQL database password to 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