how to install MariaDB and phpMyAdmin in OMV5?

I created file to install MariaDB in Portainer using stack method

"

---

version: "2.1"

services:

mariadb:

image: ghcr.io/linuxserver/mariadb:latest

container_name: mysql

environment:

- PUID=1000

- PGID=100

- MYSQL_ROOT_PASSWORD=put your password here before you add stack

- TZ=America/New_York

- MYSQL_DATABASE=mysql #optional

- MYSQL_USER=kodi #optional

- MYSQL_PASSWORD=kodi #optional

volumes:

- /srv/dev-disk-by-label-Data/AppData/Config/mysql:/config

- /srv/dev-disk-by-label-Media/Movies:/Movies

- /srv/dev-disk-by-label-Media2/Movies2:/Movies2

- /srv/dev-disk-by-label-Media/TV_Shows:/TV_Shows

- /srv/dev-disk-by-label-Media2/TV_Shows2:/TV_Shows2

- /srv/dev-disk-by-label-Media/Music:/Music

- /srv/dev-disk-by-label-Media/Concerts:/Concerts

ports:

- 3306:3306

restart: unless-stopped"

Change my "volumes:" section to reflect your set-up in OMV5

Change TZ to where you are.

Go to this page "*ttps://kodi.wiki/view/MySQL/Setting_up_MySQL#tab=Ubuntu_Linux" to set-up mysql (this is MariaDB) for user "kodi" with password "kodi" (you can change user and password to whatever you like.

If you to use kodi go to this page "*ttps://kodi.wiki/view/MySQL/Setting_up_Kodi" to see how to adjust autoexec file in kodi install.

Make sure that PUID and PGID in this file are same as in your system if not change them in this file before you add stack.

Hope this will help

Food for thoughts:

Install phpMyAdmin - Docker - openmediavault