Docker安装mysql

1. 下载mysql镜像

   docker pull mysql

   默认情况下下载最新版本,即mysql8.0

2. 允许mysql容器:注意mysql8.0与mysql5.7存在差别:

   1. 8.0

      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 \
      -v /home/mysql/mysql-files:/var/lib/mysql-files/ \
      -d mysql

       

   2. 5.7

      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配置文件:

   vi /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

   esc后,:wq退出并保存.

4. 重启mysql容器:

   docker restart mysql