MariaDB with phpmyadmin local machine development setup using docker

MariaDB with PHPMyAdmin local machine development setup using docker.
MariaDB and PHPMyAdmin setup for development on local machine using docker.

MariaDB and PhpMyAdmin docker setup in local

official website
https://hub.docker.com/_/mariadb
https://hub.docker.com/r/phpmyadmin/phpmyadmin/

preRequisties:-
Docker
mariadb
phpMyAdmin

MariaDB:-
MariaDB Server is one of the most popular database servers in the world.
It’s made by the original developers of MySQL and guaranteed to stay open source
Notable users include Wikipedia, DBS Bank, and ServiceNow.

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 mariadb:latest

$ docker run -p 127.0.0.1:3306:3306 –name dev-mariadb -e MARIADB_ROOT_PASSWORD=pass123 -d mariadb:latest

now mariadb 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-mariadb:db -p 7098:80 phpmyadmin/phpmyadmin

access PHPMyAdmin http://localhost:7098/

root and pass pass123

access using CLI

$ docker exec -it dev-mariadb bash

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

Blog
http://techwasti.com/
Medium Publication
https://medium.com/techwasti/

#docker #mariadb #phpmyadmin #kubernetes #cloud-native #techwasti