Dockerfile构建mysql数据库

dockerfile文件:
FROM centos:centos6 
MAINTAINER admin "admin@topsec.com.cn"   
RUN yum install -y mysql-server mysql 
RUN /etc/init.d/mysqld start &&\ 
    mysql -e "grant all privileges on *.* to 'root'@'%' identified by 'Talent123';"&&\ 
    mysql -e "grant all privileges on *.* to 'root'@'localhost' identified by 'Talent123';"&&\ 
    mysql -u root -pTalent123 -e "show databases;"
RUN rm -rf /etc/my.cnf
ADD my.cnf /etc/    
EXPOSE 3306  
CMD ["/usr/bin/mysqld_safe"]
 
单个构建my.cnf文件:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
lower_case_table_names = 1
character-set-server = utf8
max_connections = 5000
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log     
pid-file=/var/run/mysqld/mysqld.pid
注:my.cnf文件和dockerfile文件应该放在一起;
 
构建容器命令:
docker build -t mysql_server .
docker run -ti --name=mysqlserver -d -p 3306:3306 mysql_server
mysql -h 127.0.0.1 -u root -pTalent23 -P 3306
posted @ 2018-05-17 16:30  追逐新梦想  阅读(539)  评论(0编辑  收藏  举报