docker安装mysql:5.7

• 1 下载镜像

    docker pull mysql:5.7

• 2 创建实例并启动

    ## 反斜杠\前面要有空格！
    docker run -p 3306:3306 --name mysql \
    -v /mydata/mysql/log:/var/log/mysql \
    -v /mydata/mysql/data:/var/lib/mysql \
    -v /mydata/mysql/conf:/etc/mysql \
    -e MYSQL_ROOT_PASSWORD=root \
    -d mysql:5.7

• 3 MySQL配置

    vim mydata/mysql/conf/my.cnf

    [client]
    default-character-set=utf8

    [mysql]
    default-character-set=utf8

    [mysqld]
    init_connect='SET collation_connection = utf8_unicode_ci'
    init_connect='SET NAMES utf8'
    character-set-server=utf8
    collation-server=utf8_unicode_ci
    skip-character-set-client-handshake
    skip-name-resolve

• 4 重启MySQL

    docker restart mysql