MySQL in Docker Container

cmds.txt

#remove mysql images
docker image ls | grep mysql | cut -f 1 -d ' ' | xargs docker image rm -f

#setup docker container
docker run --name mysql0 -p 0.0.0.0:3306:3306 -p 0.0.0.0:33060:33060 -td mysql/mysql-server:8.0

#get generated password
docker logs mysql0 2>&1 | grep GENERATED

#update root's password
docker exec -it mysql0 mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';

#create users
CREATE USER 'monty'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' WITH GRANT OPTION;
CREATE USER 'monty'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' WITH GRANT OPTION;
CREATE USER 'admin'@'localhost';