FROM mysql:5.7
MAINTAINER wuhui
#字符集
RUN echo "character-set-server=utf8" >> /etc/mysql/mysql.conf.d/mysqld.cnf \
&& echo "collation-server=utf8_general_ci" >> /etc/mysql/mysql.conf.d/mysqld.cnf \
#时区
&& echo "default-time-zone"='+8:00' \
&& echo "[client]" >> /etc/mysql/mysql.conf.d/mysqld.cnf \
&& echo "default-character-set=utf8" >> /etc/mysql/mysql.conf.d/mysqld.cnf \
&& echo "[mysql]" >> /etc/mysql/mysql.conf.d/mysqld.cnf \
&& echo "default-character-set=utf8" >> /etc/mysql/mysql.conf.d/mysqld.cnf \
&& cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \
#时区
&& echo 'Asia/Shanghai' >/etc/timezone \
#解决5.7.5及以上默认启用了ONLY_FULL_GROUP_BY模式，造成group by的问题
#1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this i
&& echo "[mysqld]" >> /etc/mysql/mysql.conf.d/mysqld.cnf \
&& echo "sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" >> /etc/mysql/mysql.conf.d/mysqld.cnf \

ENTRYPOINT ["/bin/bash"]