Setup phpMyAdmin and MySQL with Docker Compose (Docker)

This tutorial will show how to configure docker container to run Phpmyadmin.

Prerequisites -
docker recommended version 19+
docker-compose recommended version 1.20+

2 Scenarios-
a. Connect to an arbitrary server db
b. Connect to a docker hosted db

Links -

#docker #phpmyadmin #phpmyadminoverdocker #dockertutorial #dockercomposetutorial

[avanox]

owmygoood!!! you are the best!!! It works perfectly!!
I was just a little confused because you used first the external msql but cool to know that exist as well 🙂 Finally it was really nice how you made this video! Now I do understand as wel more how docker-compose is working ! daaammn what a nice video!! (and a little help from chatgpt to write down the code, I had to change a few small things)

[introvertedgirlie]

I got this error "mysqli::real_connect(): (HY000/1130): Host '172.18.0.3' is not allowed to connect to this MySQL server". No matter what I do, it's not getting resolved. I saw your reply to another comment with the same issue and followed the links you suggested, but it still doesn't resolve the issue.

[avanox]

I Tried making a docker-compose file as well to connect Nextcloud to database I made for Nextcloud in phpmyadmin. But I have problems connecting them.Can you help me with this one too?

[AlaaEddineNOUILI]

Hello, thank you for this video, I try it with springboot application I find the name of the db but my database is empty, any solution plz ?

[avanox]

owkey, but I heared arbitrary is not that safe to use ? Is this right?

[nguyenhmtriet]

Hi, thank you for your video, however I follow exactly the steps but it couldn't connect to database on phpmyadmin. I got this error "mysqli::real_connect(): (HY000/1130): Host '172.18.0.3' is not allowed to connect to this MySQL server". I'm using MacOS Ventura, Docker Engine v20.10.22.

[weqtgafg]

Thank you for your video, helps a lot

[avanox]

Did you have to configure the password somewhere, I don't see you doing this