docker.start.txt 1.4 KB

123456789101112131415161718192021
  1. docker run -itd --name mysql8 -p 3307:3306 -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -v D:/MySQL/docker_mysql:/var/lib/mysql mysql:8.0.28-oracle
  2. docker run -itd --name mysql82 -p 3312:3306 -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 mysql:8.0.28-oracle
  3. mysqldump -uroot -pr6kEwqWU9!v3 -P3307 --databases qmt_stocks_whole >d:/qmt_stocks_whole.sql
  4. # version order 1
  5. docker run -itd --name mysql8 -p 3307:3306 -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -v C:/docker_mysql/stock_data:/var/lib/mysql -v C:/docker_mysql/config/mysql.cnf:/etc/my.cnf daocloud.io/library/mysql:8.0.21
  6. docker run -itd --name mysql8033 -p 3308:3306 -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -v C:/docker_mysql/0833:/var/lib/mysql -v C:/docker_mysql/conf:/etc/mysql mysql:8.0.33
  7. docker run -itd --name mysql8033 -p 3308:3306 -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -v C:/docker_mysql/mysql.cnf:/etc/my.cnf mysql:8.0.33-debian
  8. docker run -itd -p 3307:3306 --name mysql8033 -e character-set-server=utf8mb4 --privileged=true --restart unless-stopped -v C:/docker_mysql/stock_data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -d mysql:8.0.33 --skip-log-bin --disable-log-bin --lower_case_table_names=1
  9. docker run -itd -p 3307:3306 --name mysql8033 -e character-set-server=utf8mb4 --privileged=true --restart unless-stopped -v C:/docker_mysql/stock_data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -d mysql:8.0.33 --lower_case_table_names=1 --skip-log-bin --disable-log-bin