sasasasa/mysql-server repository overview

FROM mysql/mysql-server
RUN yum update -y && yum -y reinstall glibc-common
RUN localedef -v -c -i ja_JP -f UTF-8 ja_JP.UTF-8; echo "";
ENV LANG=ja_JP.UTF-8
RUN rm -f /etc/localtime && \
    ln -fs /usr/share/zoneinfo/Asia/Tokyo /etc/localtime

$ docker exec -it mysql-server mysql -uroot -psasasasa
mysql> show variables like "chara%";

/etc/my.cnf
[mysqld]
character-set-server = utf8

[mysql]
default-character-set=utf8

vi sql/database.sh

#!/bin/sh

echo "CREATE DATABASE IF NOT EXISTS \`app_test\` ;" | "${mysql[@]}"
echo "GRANT ALL ON \`app_test\`.* TO '"$MYSQL_USER"'@'%' ;" | "${mysql[@]}"

echo "CREATE DATABASE IF NOT EXISTS \`app_production\` ;" | "${mysql[@]}"
echo "GRANT ALL ON \`app_production\`.* TO '"$MYSQL_USER"'@'%' ;" | "${mysql[@]}"

echo 'FLUSH PRIVILEGES ;' | "${mysql[@]}"

$ docker run --name mysql-server -e MYSQL_DATABASE=app_development -e MYSQL_USER=sasasasa -e MYSQL_PASSWORD=sasasasa -e MYSQL_ROOT_PASSWORD=sasasasa -d -p 3306:3306 -v /home/docker/sql:/docker-entrypoint-initdb.d sasasasa/mysql-server