How does myeclipse connect to mysql database? (detailed steps)

Steps: 1. Open the Database window; 2. Right-click "new" in the blank space to create a connection; 3. In the pop-up window, select the connection method, fill in the configuration information, and add the driver; 4. Test the configuration Is it correct? The test is successful. Click Finish to complete the connection creation; 5. Right-click the connection, click "Open.." and enter the password.

Detailed steps for myeclipse to connect to mysql database

First step, open Database

Open myeclipse and click on the window window. Click MyEclipse Database Explorer

Picture 1

Second Step 1: Create a connection

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

Figure 2

The Database Driver menu pops up (Figure 3)

The third step is to select the connection method

Figure 3

Select MySql Connector/j in the Driver template option box, for example, Figure 4

The fourth step is to fill in the configuration information

Figure 4

Fill in the name of the linked database in Driver name (this can be filled in according to your own preferences, it is recommended that it be related to the name of the project for ease of use) Find).

Connection URL is used to fill in the address of the mysql database to be connected (jdbc:mysql:// [<:3306>]/ ) which can be changed to (jdbc:mysql: //localhost:3306/test), where localhost means connecting to the local database, 3306 means the port number for connecting to the mysql database (different database port numbers are different),

User name fills in the database The default user name mysql is rootPassword. Fill in the access password you set when accessing the mysql database. For example, Figure 5

Figure 5

The fifth step is to add the driver

Figure 6

Click Add JARs to add the driver file for myeclipse to connect to the mysql database (it is best to store the driver file in an English directory. Make sure the mysql database is open during the test, otherwise the test will not succeed). What is added here is mysql -connector-java-5.1.7-bin version (you can search and download it online). For example, Figure 7

The sixth step is to test whether the data configuration is correct

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. Test successful

Figure 9

The test connection to the mysql database is successful, click Finish to complete the creation of the connection

Step 8, connect to the database

Figure 10

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

Picture 11

Picture 12

Recommended learning:mysql tutorial

The above is the detailed content of How does myeclipse connect to mysql database? (detailed steps). For more information, please follow other related articles on the PHP Chinese website!