MySQL and Oracle Database Installation Guide

MySQL Installation Guide

1. Download MySQL Installer

Open the official MySQL website:

https://dev.mysql.com/downloads/installer/

Download:

mysql-installer-community
Version Description
Web Installer Small download, downloads components during install
Full Installer Large download, includes everything
Recommended: Full Installer

2. Run the Installer

Double-click the installer and choose Setup Type.

Option Description
Developer Default Installs MySQL Server + Workbench + Tools
Server Only Only database server
Client Only Only client tools
Custom Manual component selection 
Recommended: Developer Default

3. Check Requirements

Click Execute to install missing requirements.

4. Install MySQL Products

Click:

Execute

Components installed:

5. Configure MySQL Server

Application
    |
    | JDBC
    v
+-------------+
|  MySQL DB   |
| Port 3306   |
+-------------+

6. Test MySQL Installation

mysql -u root -p
SHOW DATABASES;

7. Create Database for Spring Boot

CREATE DATABASE springboot_db;
USE springboot_db;

8. Spring Boot Connection Example

spring.datasource.url=jdbc:mysql://localhost:3306/springboot_db
spring.datasource.username=root
spring.datasource.password=root123
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true

Oracle Database Installation Guide

Download Oracle XE

https://www.oracle.com/database/technologies/xe-downloads.html

Extract ZIP and Run

setup.exe

Default Installation Path

C:\app\oracle\product\21c\dbhomeXE

Ports

Service Port
Listener 1521
EM Express 5500 
Spring Boot App
      |
      | JDBC
      v
+----------------+
| Oracle DB XE   |
| Port 1521      |
+----------------+

Create User

CREATE USER springuser IDENTIFIED BY spring123;
GRANT CONNECT, RESOURCE TO springuser;

Spring Boot Oracle Configuration

spring.datasource.url=jdbc:oracle:thin:@localhost:1521/XEPDB1
spring.datasource.username=springuser
spring.datasource.password=spring123
spring.jpa.database-platform=org.hibernate.dialect.Oracle12cDialect