Install MySQL and navicat, and connect with MyEclipse

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.