using a phpmyadmin container to manage the mariadb database

[alexandrecuer]

This isn't essential, since the backup module and home-assistant-specific backups are available if you use the addon, but it can be a useful tool. With docker-compose, things are pretty obvious, but inside home assistant supervised, it's a little more complex.

The most convenient way is to use the official docker container, through a very light Dockerfile :

FROM phpmyadmin:latest

ENV \
    PMA_ARBITRARY=1

ENTRYPOINT [ "/docker-entrypoint.sh" ]
CMD ["apache2-foreground"]

the minimum config.yaml file consists of the following instructions

name: "phpmyadmin2emoncms"
description: "manage emoncms maria database with phpmyadmin"
version: "1.0.0"
slug: "phpmyadmin2emoncms"
init: true
webui: http://[HOST]:[PORT:8080]
arch:
  - aarch64
  - amd64
  - armv7
ports:
  80/tcp: 8080

These 2 files go into the phpmyadmin2emoncms directory to be created in the home-assistant addons folder.

Ingress mode will not be available for this local phpmyadmin addon

Last versions of the emoncms addon allow connection from the home assistant addon network

For general knowledge, to allow connections from the addon internal network, you need to run the following SQL :

GRANT ALL ON emoncms.* TO 'emoncms'@'172.30.33.%' IDENTIFIED BY 'your_password';
flush privileges;

When connecting use 60ed1c84-emoncms for the server name