Introduction
Configuring a new data source in IntelliJ IDEA is fairly simple. You'll need to provide some basic information about your data source such as database name, database connection port, etc. So, as software developers, an inbuilt data source in your editor will save much development/testing time and it'll be user-friendly because no need to switch between your editor and another third-party Database connection software.
So, Let's have look at how to configure a new data source in IntelliJ IDEA
❄️ For Example, I here describe how to create a new data source only for MySQL. But the flow of the configuration process is approximately identical. I hope that by examining this example you'd not get hard to configure for other Database types also.
To Configure a new Data Source in IntelliJ IDEA
1. Open up your IntelliJ IDEA on your PC.
2. Then navigate to the Databases tab located in the Right corner of the IDE.
2. Then navigate to the Databases tab located in the Right corner of the IDE.
3. Then make sure that which database you want to configure and make sure that it already exists before start the configuration setup. (Ex:- consider a database called supermarket)
4. Then again let's switch back to IntelliJ IDEA IDE. Locate and select on the + mark and click
Data Source > MySQL.
5. Then you have to provide very basic information about your database such as database name, database port (to me MySQL default port: 3306), host (to me it's localhost). Once you have filled in all this information you can click Test Connection to confirm/check whether you've entered correct information about the database. After successful confirmation, it'll display a message with a green tick to indicate that you provided information is correct. Then click Apply and OK, then you will see a database on the database tab.
6. After completing the above step you will see already a new data source available on the database tab in the IDE. It'll display one out of all databases amount in front of the Database Name (Eg: - 1 of 6). Locate on that bale and point your cursor to it. So it'll display a tooltip saying 0 connections which means that your data source hasn't already had any connections established.
7. Then you can simply click on that label which indicating the no of databases (Eg:- 1 of 6) and select the current schema (Eg:- supermarket).
8. Now you have all done perfectly!. Finally, it looks like this. Enjoy coding with IntelliJ IDEA.
Keywords:
create a database in mysql
create a database in excel
create a database in postgres
create a database
intellij plugins
java ide>
intellij
intellij idea
intellij download
intellij idea ultimate
data source
data source settings power bi
data sources in research
data source company
0Comments