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/