wangcaitao/mysql repository overview

⁠Dockerfile link

• 5.6.45⁠
• 5.7.23⁠

⁠使用说明

1. 确定用户 root 密码, 如 MYSQL_ROOT_PASSWORD=password, 运行命令中可修改

2. 运行命令

   • 5.6.x: # docker run -d --restart always --name mysql -p 3306:3306 -v mysql:/var/lib/mysql -v mysql-conf:/etc/mysql -e MYSQL_ROOT_PASSWORD=password wangcaitao/mysql:tagname
   • 5.7.x: # docker run -d --restart always -p 3306:3306 -p 33060:33060 --name mysql -v mysql:/var/lib/mysql -v mysql-conf:/etc/mysql -e MYSQL_ROOT_PASSWORD=password wangcaitao/mysql:tagname

3. # vim /var/lib/docker/volumes/mysql-conf/_data/conf.d/mysql.cnf

   [mysql]
   
   # region add
   character_set_database = utf8mb4
   # endregion
   

   Copy

4. # vim /var/lib/docker/volumes/mysql-conf/_data/mysql.conf.d/mysqld.cnf

   [mysqld]
   
   # region add
   skip_ssl
   character_set_server = utf8mb4
   default-time-zone = '+08:00'
   # endregion
   

   Copy

5. # docker restart mysql

⁠版本说明

⁠5.6.45

• 修改系统时间为北京时间

⁠5.7.23

• 修改系统时间为北京时间