Tuesday, February 21, 2023

HOW TO CREATE A NEW INSTANCE PHPMYADMIN IN DOCKER, DIRECTLY TO YOUR CLOUD SERVER

You can use this whenever you want another instance of phpmyadmin connected to your cloud mysql server

docker run --name phpmyadminContainerName -d -e PMA_HOST=[hostname] -e PMA_USER=[user] -e PMA_PASSWORD=[password] -p 8088:80 phpmyadmin/phpmyadmin

Replace [YOUR_HOSTNAME], [YOUR_USERNAME], and [YOUR_PASSWORD] with your own values. This command will start the phpMyAdmin container in the background and expose it on port 8088 of your local machine. You can access phpMyAdmin by opening a web browser and navigating to http://localhost:8088.

Monday, February 20, 2023

INSTALL MYSQL with PHPMYADMIN in DOCKER (Windows)

1. Install docker for windows https://docs.docker.com/desktop/install/windows-install/

2. After installation, start docker daemon by simply open the docker program.

3. Open any terminal and create docker network.

docker network create docker-network

4. Install mysql using the command below:

docker run --name mysql --network docker-network -p 3306:3306 -v mysql-data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=secret -d mysql

5. Install phpmyadmin using the command below:

docker run --name phpmyadmin --network docker-network -d --link mysql:db -p 8888:80 phpmyadmin


Congratulation! You may now access your mysql server using phpmyadmin @ http://localhost:8888