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;