Month: September 2020

docker에서 mysql 실행하기



docker volume create mysqldb


docker pull mysql
docker image history mysql (##포트 확인)


docker run –name yslee-mysql -p 3306:3306 -v mysqldb:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=password -d mysql


docker exec -it yslee-mysql bash
mysql -u root -p
show databases;
use mysql;
show tables;
create table tbl1 (id int);
show tables;
insert into tbl1 values (100);
insert into tbl1 values (200);
select * from tbl1;

select database();
select version();
select now();
exit
exit


docker volume inspect mysqldb;
cd /var/lib/docker/volumes/mysqldb/_data
ls -l
ls -l mysql/