docker mysql

docker run -p 12345:3306 --name mysql -v /myfolder/mysql/conf:/etc/mysql/conf.d -v /myfolder/mysql/logs:/logs -v /myfolder/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=12345 -d mysql:5.6

docker exec -it 347598sadf9 /bin/bash

mysql -uroot -p

show database
create database db01;
use db01;


外部连接mysql服务
check  终端ip     ifconfig
192.168.202.135


backup database
docker exec 347598sadf9 sh -c ' exec mysqldump --all-database -uroot -p "12345" ' > /myfolder/all-databases.sql