Part 1 - Maria SQL Database

MariaDB

Supported Architectures

We utilise the docker manifest for multi-platform awareness. More information is available from docker here and our announcement here.

Simply pulling lscr.io/linuxserver/mariadb:latest should retrieve the correct image for your arch, but you can also pull specific arch images via tags.

The architectures supported by this image are:

MYSQL_ROOT_PASSWORD="ROOT_ACCESS_PASSWORD"
MYSQL_DATABASE="USER_DB_NAME"
MYSQL_USER="MYSQL_USER"
MYSQL_PASSWORD="DATABASE_PASSWORD"
REMOTE_SQL="http://URL1/your.sql,https://URL2/your.sql"

Docker Compose

---
version: "2.1"
services:
  mariadb:
    image: lscr.io/linuxserver/mariadb:latest
    container_name: mariadb
    environment:
      - PUID=1000
      - PGID=1000
      - MYSQL_ROOT_PASSWORD=ROOT_ACCESS_PASSWORD
      - TZ=Europe/London
      - MYSQL_DATABASE=USER_DB_NAME #optional
      - MYSQL_USER=MYSQL_USER #optional
      - MYSQL_PASSWORD=DATABASE_PASSWORD #optional
      - REMOTE_SQL=http://URL1/your.sql,https://URL2/your.sql #optional
    volumes:
      - path_to_data:/config
    ports:
      - 3306:3306
    restart: unless-stopped

---

Imagem MariaDB

---

Volume MariaDB

---

Environmental MariaDB

---

Restart Policy

---

Deploy The Container

---

PuTTY

---

Docker Exec

Acessar o Container

docker exec -it mariadb bash

Login Como Root

mysql -uroot -p

Senha

test123

Create New User

CREATE USER 'user' IDENTIFIED BY 'test123';

Create NewDataBase

CREATE DATABASE IF NOT EXISTS nextcloud;

Privileges On nextcloud Database

GRANT ALL PRIVILEGES ON nextcloud.*TO 'user' IDENTIFIED BY 'test123';

Exit

quit
exit

---

Part 2 - NextCloud

NextCloud

Docker Compose NextCloud

---
version: "2.1"
services:
  nextcloud:
    image: lscr.io/linuxserver/nextcloud:latest
    container_name: nextcloud
    environment:
      - PUID=1000
      - PGID=1000
      - TZ=Europe/London
    volumes:
      - /path/to/appdata:/config
      - /path/to/data:/data
    ports:
      - 443:443
    restart: unless-stopped

Docker Compose Customized

---
version: "2.1"
services:
  nextcloud:
    image: lscr.io/linuxserver/nextcloud:latest
    container_name: nextcloud
    environment:
      - PUID=1000
      - PGID=100
      - TZ=Brazil
    volumes:
      - /srv/dev-disk-by-label-data/dockerapp/nextcloud:/config
      - /home/biolabs/aws/32.Storage/nextcloud/data:/data
    ports:
      #- 443:443
      - 444:443
    restart: unless-stopped

NextCloud User

v