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 -
Official Docker Hub Website - hub.docker.com/
phpmyadmin image - hub.docker.com...
#docker #phpmyadmin #phpmyadminoverdocker #dockertutorial #dockercomposetutorial

[@avanox3100]

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)

[@CloudGurus]

Glad it helped!

[@weqtgafg2212]

Thank you for your video, helps a lot

[@CloudGurus]

You are welcome!

[@JoaoPedro-uw8nz]

Thx for the help :)

[@CloudGurus]

Happy to help

[@AkshadRathod-w2r]

helful video ..

[@CloudGurus]

Thanks for the feedback.

[@zuggrr]

thank you soo much !

[@CloudGurus]

You're welcome!

[@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.

[@CloudGurus]

Refer these links: github.com/docker-library/mysql/issues/275
stackoverflow.com/questions/54030469/host-x-is-not-allowed-to-connect-to-this-mysql-server

[@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 ?

[@CloudGurus]

Please share the error code.

[@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.

[@CloudGurus]

Refer these links: github.com/docker-library/mysql/issues/275
serverfault.com/questions/793058/can-not-access-mysql-docker
stackoverflow.com/questions/54030469/host-x-is-not-allowed-to-connect-to-this-mysql-server
www.tecmint.com/fix-error-1130-hy000-host-not-allowed-to-connect-mysql/

[@avanox3100]

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?

[@CloudGurus]

Please share the error code.

[@avanox3100]

I wil show my docker compose file tomorrow in your Twitter in private

[@avanox3100]

@@CloudGurus I tried sending an email

[@avanox3100]

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

[@CloudGurus]

Alright.

[@avanox3100]

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

[@CloudGurus]

Yes correct.

[@comptegmail273]

Hi sir can I contact you on your social media or mail to help solve an issue i'm dealing with. For my spring boot project, my database is opened using phpmyadmin (sql) but I didn't know if I have to only put a server for mysql or both for mysql and phpmyadmin when I run dockercompose it doesn't seem to have any connection,

[@CloudGurus]

Contact us here: [e-mail]

[@comptegmail273]

@@CloudGurus I just sent thanks guys