Useful Commands

Run MySQL in a docker container

1. Run the container

docker run --name agenda_mysql -e MYSQL_ROOT_PASSWORD=p4ssw0rd -p 3306:3306 -d mysql:latest

2. Access mysql cli inside the container

docker exec -it agenda_mysql mysql -uroot -p

3. Create the "db_agenda" database and "tb_agenda" table

CREATE DATABASE db_agenda;

USE db_agenda;

CREATE TABLE tb_agenda
(
codigo int auto_increment primary key,
nome varchar(50) not null,
endereco varchar(50) not null,
telefone char(11) not null,
email varchar(60)
);