5.6 (5.6/Dockerfile)基于Docker hub里mysql:5.6（docker pull mysql:5.6）（https://hub.docker.com/_/mysql/ ）根据实际情况改造而成。
修改Mysql字符集为UTF8，默认是latin1
MYSQL_ROOT_PASSWORD: MYSQL数据库ROOT密码MYSQL_DATABASE: 新建Mysql数据库MYSQL_USER: 新建Mysql用户MYSQL_PASSWORD: 新建Mysql用户的密码，注：MYSQL_DATABASE，MYSQL_USER，MYSQL_PASSWORD三者合用，意思是将MYSQL_DATABASE授权给MYSQL_USERversion: '2'
services:
db:
image: yfshare/mysql:5.6
container_name: mysql
environment:
MYSQL_ROOT_PASSWORD: '20180223@123456'
MYSQL_DATABASE: 'testdb'
MYSQL_USER: 'testuser'
MYSQL_PASSWORD: 'testpass@20180223'
ports:
- 3306:3306
volumes:
- /data/docker_mount/mysql:/var/lib/mysql
- /etc/localtime:/etc/localtime:ro
restart: always
docker pull yfshare/mysql:5.6
docker-compose -f mysql-compose.yml up -d
docker exec -it mysql /bin/bash
查看修改后的Mysql字符集
mysql> SHOW VARIABLES LIKE 'character_set_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql>
Content type
Image
Digest
Size
100.2 MB
Last updated
over 8 years ago
docker pull yfshare/mysql:5.6