FROM mysql:5.7

#設(shè)置免密登錄
ENV MYSQL_ALLOW_EMPTY_PASSWORD yes

#將所需文件放到容器中
COPY setup.sh /mysql/setup.sh
COPY schema.sql /mysql/schema.sql
COPY privileges.sql /mysql/privileges.sql

#設(shè)置容器啟動(dòng)時(shí)執(zhí)行的命令
CMD ["sh", "/mysql/setup.sh"]

#!/bin/bash
set -e

#查看mysql服務(wù)的狀態(tài)，方便調(diào)試，這條語(yǔ)句可以刪除
echo `service mysql status`

echo '1.啟動(dòng)mysql....'
#啟動(dòng)mysql
service mysql start
sleep 3
echo `service mysql status`

echo '2.開始導(dǎo)入數(shù)據(jù)....'
#導(dǎo)入數(shù)據(jù)
mysql < /mysql/schema.sql
echo '3.導(dǎo)入數(shù)據(jù)完畢....'

sleep 3
echo `service mysql status`

#重新設(shè)置mysql密碼
echo '4.開始修改密碼....'
mysql < /mysql/privileges.sql
echo '5.修改密碼完畢....'

#sleep 3
echo `service mysql status`
echo `mysql容器啟動(dòng)完畢,且數(shù)據(jù)導(dǎo)入成功`

tail -f /dev/null

-- 創(chuàng)建數(shù)據(jù)庫(kù)
create database `docker_mysql` default character set utf8 collate utf8_general_ci;

use docker_mysql;

-- 建表
DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
 `id` bigint(20) NOT NULL,
 `created_at` bigint(40) DEFAULT NULL,
 `last_modified` bigint(40) DEFAULT NULL,
 `email` varchar(255) DEFAULT NULL,
 `first_name` varchar(255) DEFAULT NULL,
 `last_name` varchar(255) DEFAULT NULL,
 `username` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 插入數(shù)據(jù)
INSERT INTO `user` (`id`, `created_at`, `last_modified`, `email`, `first_name`, `last_name`, `username`)
VALUES
  (0,1490257904,1490257904,'john.doe@example.com','John','Doe','user');

use mysql;
select host, user from user;
-- 因?yàn)閙ysql版本是5.7，因此新建用戶為如下命令：
create user docker identified by '123456';
-- 將docker_mysql數(shù)據(jù)庫(kù)的權(quán)限授權(quán)給創(chuàng)建的docker用戶，密碼為123456：
grant all on docker_mysql.* to docker@'%' identified by '123456' with grant option;
-- 這一條命令一定要有：
flush privileges;

docker build -t 13/docker-mysql .

docker run -d -p 13306:3306 13/docker-mysql

docker exec -it 9db491b1d760 /bin/bash