Home  >  Article  >  Database  >  How does IntelliJ IDEA connect to MySQL database?

How does IntelliJ IDEA connect to MySQL database?

青灯夜游
青灯夜游Original
2019-06-01 13:27:0750588browse

How does IntelliJ IDEA connect to MySQL database?

Steps for IntelliJ IDEA to connect to MySQL database:

1. From the menu View→Tool Windows→Database Open the database tool window, as shown in the figure below:

#2. Click the add button " " in the upper left corner of the Database tool window and select the database type. Here, MySQL is used For example, as shown in the figure below:

If you are connecting to the database for the first time, you have to download the file corresponding to MySQL connection

How does IntelliJ IDEA connect to MySQL database?

3. Fill in the host name, database name, user name and password of the database connection, as shown in the figure below:

4. Click the Test Connection button to test whether the database connection is Normal

How does IntelliJ IDEA connect to MySQL database?

The picture below is a screenshot of a normal connection

If the connection can be successful, a message will appear Forgive the successful color

5. Finally, Apply and Ok

After successfully connecting to the database, you can view the data table currently connected to the database in the window shown in the red box on the right. The red box on the left The box is the data of the selected table, as shown in the following figure:

Recommended related articles:
1.The first step in idea learning Detailed explanation of its use
2.The second step of idea learning: It is strongly recommended to modify the configuration for the initial installation

The above is the detailed content of How does IntelliJ IDEA connect to MySQL database?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn