docker mysql5.7操作命令

mysql 5.7 docker image 操作流程

环境介绍

• ubuntu 14.04 LTS
• docker 17.05.0-ce
• docker-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;