Docker 安装Mysql 并挂载配置文件

Docker 安装Mysql 并挂载配置文件

1. 新建文件夹和文件

   • 新建文件夹 /home/mysql/data

   • 新建文件/home/mysql/conf/my.cnf,内容如下:

     [mysqld]
     pid-file        = /var/run/mysqld/mysqld.pid
     socket          = /var/run/mysqld/mysqld.sock
     datadir         = /var/lib/mysql
     lower_case_table_names=1
     #log-error      = /var/log/mysql/error.log
     # By default we only accept connections from localhost
     #bind-address   = 127.0.0.1
     # Disabling symbolic-links is recommended to prevent assorted security risks
     symbolic-links=0
     
     

2. 下载并启动mysql

   docker run --name mysql5.7  --privileged=true   \
   -p 3306:3306   \
   -v /home/mysql/conf/my.cnf:/etc/mysql/mysql.conf.d/mysqld.cnf   \
   -v /home/mysql/data:/var/lib/mysql   \
   -e  MYSQL_ROOT_PASSWORD="123" -d mysql:5.7
   

   解释:

   –privileged=true：提升容器内权限
   -v /home/mysql/conf/my.cnf:/etc/mysql/mysql.conf.d/mysqld.cnf：映射配置文件
   -v /home/mysql/data:/var/lib/mysql：映射数据目录
   -e MYSQL_ROOT_PASSWORD=”123”：设置root的密码
   

   ​