Shulou(Shulou.com)06/01 Report--

This article is about how to connect myeclipse and mysql database, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Steps: 1, open the Database window; 2, right-click "new" in the blank to create a connection; 3, in the pop-up window, select the connection mode, fill in the configuration information, and add the driver; 4, test whether the configuration is correct, the test is successful, click Finish to complete the creation of the connection; 5, right-click the connection, click "Open..", enter the password.

Detailed steps for myeclipse to connect to mysql database

Step 1: open Database

Open myeclipse and click the window window. Click MyEclipse Database Explorer in the Open Perspective menu.

Figure 1

Step 2, create a connection

Right-click in the space to create a new (i.e. new) or click the shortcut key in the menu bar (downward triangle symbol) to create a new one.

Figure 2

See the pop-up Database Driver menu (figure 3)

The third step, choose the connection mode.

Figure 3

Select MySql Connector/j in the Driver template option box, as shown in figure 4

Step 4, fill in the configuration information

Figure 4.

Fill in the name of the linked database in Driver name (this can be filled in as you like, and it is recommended to find it when it is easy to use related to the name of the project you are doing).

Connection URL is used to fill in the address to connect to the mysql database (jdbc:mysql:// [] /) can be changed to (jdbc:mysql://localhost:3306/test), where localhost means to connect to the local database, and 3306 is the port number to connect to the mysql database (different database port numbers are also different)

User name fill in the database user name mysql default is rootPassword fill in the access password you set when accessing the mysql database. For example, figure 5

Figure 5

Step 5, add drivers

Figure 6

Click Add JARs to add the driver file for myeclipse to connect to the mysql database (preferably an English directory for the driver file. Make sure that the mysql database is open during the test, otherwise the test will not be successful). What is added here is the mysql-connector-java-5.1.7-bin version (you can search and download it on the Internet), as shown in figure 7.

Step 6, test whether the data is configured correctly.

Figure 7.

Click Test Driver to test whether the configuration is successful, and enter the password to access the database. For example, figure 8

Figure 8.

Step 7, the test is successful

Figure 9.

Test connection to mysql database is successful. Click Finish to finish creating the connection.

Step 8, connect to the database

Figure 10

Right-click the connection you created and click Open another connection to enter the mysql database password to see the database table you created.

Figure 11

The above is how to connect myeclipse and mysql database, the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.