Install phpMyAdmin

An internet search search for "setup phpMyAdmin" didn't provide hits to https://docs.phpmyadmin.net/en/latest/setup.html?

As with any other web-based application the default port it listens to is 80, hence must be configured to have access to OMV and the new tool in parallel. (see https://docs.phpmyadmin.net/en…etup.html#envvar-PMA_PORT)

Quote from Nick0

There are lots of guides out there but most are tailored to setting up MariaBD and phpMyAdmin at the same time using Docker. I don't want to try this in case I mess things up!

Use docker. Then you won't mess up anything in your OS. That is benefit of docker. I would use the official phpmyadmin docker image - https://hub.docker.com/_/phpmyadmin. It has instructions on how to create it on the docker hub page.

Quote from Nick0

Hi there,

Can anyone tell me, or point me to a beginner's how-to, to install phpMyAdmin on OMV5? I have Docker running MariaDB and Piwigo and I have lost my password to Piwigo after setting it all up again last night. I thought my browser had saved it but seems not! I'd like to perhaps reset the password in the database using phpMyAdmin.

There are lots of guides out there but most are tailored to setting up MariaBD and phpMyAdmin at the same time using Docker. I don't want to try this in case I mess things up!

Thanks,

Nick.

Display More

Perhaps a simpler solution would be Keepass. It's free to install, just don't forget your "master" password, and you'll be fine. If you mount a Google Drive, Dropbox, etc. folder on your PC, it will always be backed up to the cloud. I prefer keepass2 as it has a better GUI, but 1 & 2 seem to be actively maintained.

I've used it for years and paid for the Android app so I'd have it on my phone (this allows you to access a database on Google Drive, Dropbox, etc.)

Quote from Nick0

I am more looking to set it up with Docker

AFAIK you can use an existing docker mariadb, which you have created, so in the compose file you direct phpMyAdmin to that running docker ........................... and before you ask, sorry I don't know, but I know a man who 'might' macom

If you use the docker-compose from the official phpmyadmin page I linked to, it uses an internal mariadb database (required by phpmyadmin). Then you can connect to any external mysql/mariadb database to admin it. You won't be able to use the mariadb database spun up by the compose for anything but you shouldn't need to. Just spin up another mysql/mariadb container.

Why do you want phpMyAdmin? Just connect to the container "docker exec -it <container-name> /bin/bash" and run mysqlclient? Ods are your MariaDB still will need configuring to accept requests from outside the container, although I have no idea what image you are using and downloaded.

Quote from Nick0

If I now head over to 192.168.1.xxx:8080, I get to the login page, where I leave the server address empty, the user: root; password: password. That gets me in but I don't see my Piwigo database, so what am I doing wrong, please?

You need to fill in the server name with the hostname where the database you want to connect to lives.

Quote from Nick0

That's what I thought but where do I find that?

I can't answer that. Where is mysql or mariadb installed that you forgot the password?

Quote from Nick0

I hope that's what you need.

Nope. Just wanted the hostname. Is mariadb created with piwigo by docker-compose? I need to know how mariadb is created.

Quote from Nick0

find the hostname. MariaDB was created by the stack,

The hostname is not of the docker container. It is the docker host hostname. What did you name the box the container is running on?

Quote from Nick0

as I used this tutorial. Thanks.

That tutorial uses compose and is exposing port 3306. So, if you use the box's hostname, it should work.

Hello all

Don't mean to hijack the thread but if this is not the right place, please feel free to move it/delete it but it concerns the same, sort of.

My idea is to install and then, create a SWAG subdomain access to the phpmyadmin container to my already running docker-compose.yml (Nextcloud, SWAG, MariaDb, Redis) but, since I already have a running SQL server:

1 - Can I add the docker-compose part of phpmyadmin and use the existing DB?

Something in these lines:

## New service to add:
  phpmyadmin:
    image: phpmyadmin
    container_name: phpmyadmin
    restart: unless-stopped
    ports:
      - xxxx:80 <<<<---- SWAG will upstream the port to xxxx on the "phpmydamin.subdomain.conf"?????
    environment:
      - PMA_HOST=mariadb
## Existing MySQL server running a nextcloud db:
  mariadb:
    image: webhippie/mariadb:latest
    container_name: mariadb
    environment:
      - MARIADB_ROOT_PASSWORD=******* <<<<--- Existing Root password
      - MARIADB_DATABASE=nextcloud <<<<---- Main concern if this will give any trouble!!!!
      - MARIADB_USERNAME=****** <<<<---- User Created at startup with administrator rights
      - MARIADB_PASSWORD=****** <<<<---- User password for the above

After this, and after editing the "phpmyadmin.subdomain.conf" upstream port with "port=xxxx" would:

--->>> docker-compose pull phpmyadmin

--->>> docker-compose up -d phpmyadmin

And finally, would open "h**ps://phpmyadmin.my.subdomain.url" and the page should come up.

Does this looks doable or, maybe some different approach is advisable???

Thank you for your help