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