docker mysql5.7操作命令

mysql 5.7 docker image 操作流程

环境介绍

ubuntu 14.04 LTSdocker 17.05.0-cedocker-compose 8.0

一、启动mysql5.7容器

# docker-compose.yml文件 version: '2' services: db: image: mysql:5.7 restart: always ports: - "3306:3306" volumes: - /data/mysql:/var/lib/mysql environment: MYSQL_ROOT_PASSWORD: mypassword MYSQL_DATABASE: data MYSQL_USER: username MYSQL_PASSWORD: password sudo docker-compose up -d

二、进入mysql5.7容器

sudo docker exec -it container_id/container_name bash

三、操作数据库

mysql -u root -p # enter the password show databases; use databasename;