Linux下使用Docker安装mysql

安装Docker

1. 安装必要的一些系统工具

   sudo yum install -y yum-utils device-mapper-persistent-data lvm2
   

2. 添加软件源信息，官网提供的软件源速度比较慢，这里使用阿里云的软件源。

   sudo yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo
   

3. 更新yum索引列表并安装Docker引擎

   sudo yum makecache fast 
   

   yum索引列表没有更新可以直接使用yum makecache

   sudo yum install docker-ce
   

   
   安装过程中会提示确认，输入y以确认就好。

4. 开启Docker服务

   sudo service docker start
   

安装Mysql

1. 拉取镜像，这里我使用的是5.6版本

   docker pull mysql:5.6
   

   

2. 指定配置映射启动容器

   docker run -p 3306:3306 --name mysql --restart=always --privileged=true -v /usr/local/mysql/log:/var/log/mysql -v /usr/local/mysql/data:/var/lib/mysql -v /usr/local/mysql/conf:/etc/mysql -v /etc/localtime:/etc/localtime:ro -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.6
   

3. 添加配置

   cd /usr/local/mysql/conf;
   vi my.cnf;
   

   # For advice on how to change settings please see
   
   # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
   
   # *** DO NOT EDIT THIS FILE. It‘s a template which will be copied to the
   
   # *** default location during install, and will be replaced if you
   
   # *** upgrade to a newer version of MySQL.
   
   [client]
   
   default-character-set=utf8
   
   [mysqld]
   
   #skip-grant-tables
   
   port=3306
   
   user = root
   
   #server_id = 2
   
   #skip-locking
   
   max_connections=100
   
   table_open_cache=256
   
   query_cache_size=1M
   
   tmp_table_size=32M
   
   thread_cache_size=8
   
   innodb_flush_log_at_trx_commit =1
   
   innodb_log_buffer_size=128M
   
   innodb_buffer_pool_size=128M
   
   innodb_log_file_size=10M
   
   innodb_thread_concurrency=16
   
   innodb-autoextend-increment=1000
   
   join_buffer_size = 128M
   
   sort_buffer_size = 32M
   
   read_rnd_buffer_size = 32M
   
   max_allowed_packet = 32M
   
   explicit_defaults_for_timestamp=true
   
   sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
   
   #sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
   
   # innodb_force_recovery= 1
   

4. 重启容器

   docker restart mysql
   

   如果未重启成功，可以查看日志

   docker logs -f mysql
   

   至此，mysql的安装就算完成了！