Mysql安装（ docker安装）

docker安装

1. docker pull mysql:5.7

2. 启动容器

   docker run -p 3306:3306 --name mysql --privileged=true -v /mydata/mysql/log:/var/log/mysql -v /mydata/mysql/data:/var/lib/mysql -v /mydata/mysql/conf:/etc/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
   

   

3. 进入数据卷进行Mysql配置

   cd /mydata/mysql/conf

   

   配置内容

   [client]
   default-character-set=utf8
   [mysq1]
   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

5. 外部访问测试