We configure the DataSource and connection pool in the application.properties. Spring Boot uses the spring.datasource interface as a prefix to configure DataSource. Our database schema name is packtpub_dbtest_schema. You can create this on your own and rename it. Here are the details of application.properties:
# Database Configuration
spring.datasource.url=jdbc:mysql://localhost:3306/packtpub_dbtest_schema
spring.datasource.username=root
spring.datasource.password=12345678
According to the previous code, spring.datasource.url=jdbc:mysql:
//localhost:3306/packtpub_dbtest_schema means the URL for the database schema called packtpub_dbtest_schema to access the data in the project. spring.datasource.username=root means the username of the database is root, and spring.datasource.password=12345678 means the username of the database is 12345678.
In our system, the MySQL details are as follows:
Host -- localhost // the host URL
Port -- 3306 // the host POST number
Username -- root // the username of the database
Password -- 12345678 // the password of the database
Database Name - packtpub_dbtest // the Database name
Database Schema Name - packtpub_dbtest_schema // the Database Schema name