adminprojet123/bdd repository overview

docker build -t bdd .
docker run -it --rm -d -p 3306:3306 --network test-reseau --ip 172.16.128.10 --name bdd bdd

docker network connect --ip 172.16.129.10 zone_dmz bdd
docker inspect -f '{{range.NetworkSettings.Networks}}{{.IPAddress}}{{end}}' bdd

docker exec -it web-intern service mysql restart

bind adress : 172.16.0.0

mysql_secure_installation

mysql

CREATE DATABASE example_database;
CREATE USER 'b2b'@'172.16.129.4' IDENTIFIED WITH mysql_native_password BY 'P@sswordMysql123';
GRANT ALL ON example_database.* TO 'test'@'172.16.128.4';

CREATE TABLE example_database.todo_list (
    item_id INT AUTO_INCREMENT,
    content VARCHAR(255),
    PRIMARY KEY(item_id)
);

INSERT INTO example_database.todo_list (content) VALUES ("My first important item");