docker安装mysql 5.7

强调：本人以下操作全都是root用户行执行的

1. 拉取mysql镜像

   docker pull mysql:5.7
   

2. 启动msyql容器

   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的字符集编码为utf8

   vim /mydata/mysql/conf/my.conf
   
   [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. 用户名：root 密码：root 登陆连接