MySQL with phpmyadmin using docker setup in local or development environment.

MySQL and phpmyadmin setup for development in local machine using docker. access mysql CLI utiltiy from docker container.

MySQL and PhpMyAdmin docker setup in local

official website


preRequisties:-
Docker
mysql
phpMyAdmin

MYSQL :-
MySQL is an open-source relational database management system.


PhpMyAdmin:-
phpMyAdmin is a free and open source administration tool for MySQL and MariaDB.
As a portable web application written primarily in PHP

pull docker image

$ docker pull mysql:latest

$ docker run --name dev-mysql -e MYSQL_ROOT_PASSWORD=pass123 -d mysql:latest

now mysql server is running now let us pull the phpmyadmin and create the container

$ docker pull phpmyadmin/phpmyadmin:latest

$ docker run --name dev-phpmyadmin -d --link dev-mysql:db -p 7098:80 phpmyadmin/phpmyadmin

root and pass pass123

access using CLI

$ docker exec -it dev-mysql bash

$ mysql -u root -p
select now();
select current_timestamp();
select current_date,curdate(),current_date();

Blog
Medium Publication

[pernulfo]

The best short explanation, Thks a lot

[shakeebanwar]

I am creating the database but when i connect to local development maching means outside the docker conatainer so host error why?