---
# System prepended metadata

title: Lecture Material

---

# Lecture Material

# Steps
- [Part 0](#Part-0)
- [Part 1](#Part-1)

# Part 1
## Setup MySQL and Apache Tomcat on AWS Instance

- Install Java8 on ubuntu server


```
sudo apt-get update
sudo apt-get install default-jre
sudo apt-get install default-jdk
```

- Install MySQL on Ubuntu Server
```
sudo apt-get update
sudo apt-get install mysql-server
mysql_secure_installation

// Verify it was installed
mysql -u root -p
```

- [Example: AWS Create Table and User MySQL](https://github.com/UCI-Chenli-teaching/cs122b-spring20-project1-jdbc-example)
- [Setup Tomcat on Local Machine](https://crunchify.com/how-to-start-stop-apache-tomcat-server-via-command-line-setup-as-windows-service/)





# Part 0
- Create account for AWS
- Setup a free tier [**EC2 Instance**](https://us-east-2.console.aws.amazon.com/ec2/v2/home?region=us-east-2#Instances:sort=instanceId):
    - Ubuntu 16.04 ***free-tier*** t2.micro EC2 instance
    - Create key and store in your machine
- Connect to server using ssh on the 'Connect Button'

:::danger
Make sure to ==**stop**== the machine when done!
:::

- Restart the machine and update security group by adding **your new IP as a rule**



