Viewing a Docker MySQL Database with PHPMyAdmin and Sequel Pro

In this short video, I'll show you how to view a MySQL database created with Docker in both PHPMyAdmin and Sequel Pro.

You'll learn:

- How to install and use PHPMyAdmin with docker-compose
- Use local Docker credentials in Sequel Pro
- Use docker-compose exec with Laravel's Artisan Tinker to manipulate data

Thanks Patreon Supporters:
- Sam Ross

[tannercampbell]

Another Laravel Docker video! Give the people what they want!!

[BASILHITMAN]

Thank you so much, I have been searching for hours and your video explained and fixed my problem exactly how I wanted it.

[abbassmortazavi]

hi my friend, im for first time write comment beacuse of i watch different movie about laravel with docker fortunately successfull and learn with your episode realy thankful about your this collection im so happy!!it should be ridiculous for some people but im so happy my friend, thank you very much.✌🙏🌺🌹☺😇

[FaizanAnwerAli]

You can make couple of videos with docker-compose and Laravel.

1. Memcached for caching.
2. Redis connection for session.
3. Media storage
4. Local ssl
5. Deployment on cloud. Including Heroku, AWS and Google Cloud.
6. Php Ratchet socket connection app in docker.

I have been looking for these for last 4 months.
Just subscribed to keep my self updated on these videos if you upload them.

[mgautumstark]

Excellent work. Simple and straight forward. 👍

[zaidkureshi]

Perfect explanation 👌
Can we have more videos related to laravel docker and their deployment to cloud

[bernardchisumo]

Excellent Job. Are you able to make a video for SSL Certificate as well?

[Monstajamsofficial]

Thanks for this tutorial, but why does the database data clear after you run docker down?

[JohnnyBigodes]

I love your videos. To bad you wont upload more. I think you are great at explaining things.

[aginev]

Hello Andrew, what about setting ENV PATH "$PATH:/var/www/html" at PHP Dockerfile? Just tested and works without full artisan path. Any downsides of this approach?

[pahami_bumi]

i have error when run migrate SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = vandy and table_name = migrations and table_type = 'BASE TABLE')

[ZeljkoKvebek]

When connecting to Sequel pro, in "Host" shouldn't you set IP address of the container?

[abdurrafay]

Thanks, A lot may god help you with your future

[noxire]

Hi. Big thanks for this. How can i edit php.ini? Where to find it?

[ilstar]

thank you very much, this video worked for me

[Ivan____]

I need to connect from a local host phpmyadmin to mysql in a docker container. Do you know it could be possible? Thanks

[tannercampbell]

Not related to this video demo but how would you run NPM commands inside this Laravel container (for example installing the Vue.js scaffolding) would you do that with the full path similar to something like artisan migrate/tinker. Or can you do it on the local instance?

[farishelmi]

Hi Andrew! Newbie's here. 6:40 How your users data still available even after you bring down the container? Because in my case, I lost all data after running the "docker-compose down".

[XORknight]

Is it just me who's getting the following issue? If I set the DB_host to 127.0.0.1 my migration, heidiSQL and unit tests work fine. however, the connection fails when I browse and get "SQLSTATE[HY000] [2002] Connection refused", I've fixed it by setting the DB_HOST to mysql (container name) or using its IP address, But now my migrations and tests have stopped working and getting "SQLSTATE[HY000] [2002] A connection attempt failed because the connected party did not properly respond after a period of time ..."