1、下载镜像文件
    docker pull mysql:5.7.35
    2、创建实例并启动

    1. docker run -p 3306:3306 --name mysql \
    2. -v /mydata/mysql/log:/var/log/mysql \
    3. -v /mydata/mysql/data:/var/lib/mysql \
    4. -v /mydata/mysql/conf:/etc/mysql \
    5. -e MYSQL_ROOT_PASSWORD=wangbin1314.. \
    6. -d mysql:5.7

    MySQL配置
    vim /mydata/mysql/conf/my.cnf

    1. [client]
    2. default-character-set=utf8
    4. [mysql]
    5. default-character-set=utf8
    7. [mysqld]
    8. init_connect='SET collation_connection = utf8_unicode_ci'
    9. init_connect='SET NAMES utf8'
    10. character-set-server=utf8
    11. collation-server=utf8_unicode_ci
    12. skip-character-set-client-handshake
    13. skip-host-cache
    14. skip-name-resolve
    15. datadir=/var/lib/mysql
    16. socket=/var/lib/mysql/mysql.sock
    17. secure-file-priv=/var/lib/mysql-files
    18. user=mysql

    重启MySQL
    docker restart mysql
    配置远程登录

    1. grant all on *.* to root@'%' identified by 'root' with grant option;
    2. #或者下面这一句
    3. UPDATE mysql.user SET host='%' WHERE user='root';
    4. flush privileges;