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 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

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.