Skip to content

An innovative system integrating a robust database solution with a user-friendly interface to facilitate seamless record management. Leveraging the power of MySQL and MariaDB databases, alongside the convenience of phpMyAdmin for efficient administration. The deployment is streamlined using Docker.

Notifications You must be signed in to change notification settings

lucianoscarpaci/SimpleDatabase-GUI

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 

Repository files navigation

SimpleDatabase-GUI

A Database that connects to a UI to change records

Docker Compose

To start the containers, run the following command:

docker-compose up -d

When stopping the containers, run the following command:

docker-compose down

MySQL+phpMyAdmin+Docker Instructions

docker run --name db-easthillshoppingmall -p 33060:33060 -e MYSQL_ROOT_PASSWORD=hacker -d mysql

docker exec -it db-easthillshoppingmall mysql -uroot -phacker CREATE DATABASE easthillshoppingmall;

phpMyAdmin Instructions

docker run --name phpmyadmin -d -p 8080:80 -e PMA_HOST=db-easthillshoppingmall phpmyadmin/phpmyadmin:latest

Create Network

docker network create project-network

docker network connect project-network db-easthillshoppingmall docker network connect project-network phpmyadmin-easthillshoppingmall

Export database

docker exec a254875a527f503e5d9d310ead573d5b97964f1b699f674b620c357393d670a6 /usr/bin/mysqldump -u root --password=hacker easthillshoppingmall > easthillshoppingmall.sql

About

An innovative system integrating a robust database solution with a user-friendly interface to facilitate seamless record management. Leveraging the power of MySQL and MariaDB databases, alongside the convenience of phpMyAdmin for efficient administration. The deployment is streamlined using Docker.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published