---
# System prepended metadata

title: Dockerfile

---

# Dockerfile
## clone
git clone https://github.com/hakamad73/pub
## docker
```
FROM ubuntu:latest

RUN \
    apt update && \ 
    apt install npm -y && \
    apt install mysql-server -y
```
## 手動ですること
cd pub
npm install

// sudo mysql -u root -p

```
CREATE DATABASE IF NOT EXISTS test;
USE test;
CREATE TABLE items (
    id INT(11) AUTO_INCREMENT NOT NULL,
    name VARCHAR(30) NOT NULL,
    PRIMARY KEY (id)
);
INSERT INTO items (name)
VALUES
  ('じゃがいも'),
  ('にんじん'),
  ('たまねぎ');
CREATE USER 'ubuntu'@'localhost' identified with mysql_native_password by 'password'
```