Spring Boot Masterclass – Setup the MySQL database 02

Hello in this post, we will set up the MySQL database and we configure the data source in the spring boot project. let’s begin.

Create a MySQL database,

CREATE DATABASE ecom;

Execute the query to create the expense table,

CREATE TABLE tbl_expenses
(
    id BIGINT(20) PRIMARY KEY NOT NULL AUTO_INCREMENT,
    amount DECIMAL(19, 2) NOT NULL,
    created_at BIGINT(20) NOT NULL,
    description VARCHAR(255) NOT NULL,
    note VARCHAR(255)
);



Next, configure the data source in the spring boot project. Add the following code inside the application.properties file

spring.datasource.url=jdbc:mysql://localhost:3306/ecom?useSSL=false
spring.datasource.username=expensetracker
spring.datasource.password=expensetracker

# spring.jpa.generate-ddl=true

 

About the author

Bushan Sirgur

Hey guys, I am Bushan Sirgur from Banglore, India. Currently, I am working as an Associate project in an IT company.

View all posts

2 Comments

  • Hi Bushan,
    I started to work on an Angular 8/Spring boot project you shared on YouTube and found out later that those videos are no more there. Shall we expect that you share them again?

    Thank you.

    • Hello,

      I am really sorry! I removed those videos as i was working for same project in my organization, they saw those videos and told me to remove as they violates the company policy. So i removed them! I will re-create those videos may be the future. But for now you can watch my other course Spring Boot Masterclass 🙂 Let me know if you need anything else.

Leave a Reply

Your email address will not be published. Required fields are marked *