docker安装mysql

Posted by Clear Blog on February 8, 2018

simple run

docker run –name mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:8

completed run

1
2
3
4
5
6
docker run --name mysql 
    -v /Users/xuguangwu/server/mysql/conf.d:/etc/mysql/conf.d \
    -v /Users/xuguangwu/server/mysql/data:/var/lib/mysql \
    -v /Users/xuguangwu/server/mysql/log:/var/log/mysqld.log \
    -p 3306:3306 \
    -e MYSQL_ROOT_PASSWORD=123456 -d mysql:8

creating database dumps

$ docker exec mysql sh -c ‘exec mysqldump –all-databases -uroot -p”$MYSQL_ROOT_PASSWORD”’ > /Users/xuguangwu/server/mysql/dump/all-databases.sql