拉取官方MySQL镜像
[root@instance-7tgaowaa ~]# docker pull mysql:5.6
查看拉取的镜像
[root@instance-7tgaowaa ~]# docker images |grep mysql
mysql 5.6 7edb93321b06 38 hours ago 256MB
拉下来以后大可以按照官方的说明无脑启动,但是外部无法访问,所以绑定端口:
[root@instance-7tgaowaa ~]# docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.6
39d7467ddf2fa5400812cbdbffb67042785fac844ff14df7583c2348659ccf3b
查看运行的镜像
[root@instance-7tgaowaa ~]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
39d7467ddf2f mysql:5.6 "docker-entrypoint.s…" 4 seconds ago Up 3 seconds 0.0.0.0:3306->3306/tcp mysql
f18fd5277e56 redis "/bin/sh -c 'redis-s…" 44 hours ago Up 44 hours 0.0.0.0:6379->6379/tcp redis
进入容器
[root@instance-7tgaowaa ~]# docker exec -it mysql bash
root@39d7467ddf2f:/# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
root@39d7467ddf2f:/# mysql -uroot -p123456
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.41 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
挂载目录到容器
[vip]
创建用于挂载的目录
[root@instance-7tgaowaa ~]# mkdir -p /home/mysql/datadir
[root@instance-7tgaowaa ~]# mkdir -p /home/mysql/conf.d
使用镜像创建容器
[root@instance-7tgaowaa ~]# docker run --name mysql -p 3306:3306 -v /home/mysql/datadir:/var/lib/mysql -v /home/mysql/conf.d:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.6
88784dd4b1fef7f9117cb2028b7ba5a0ea923790da301c63ce00b0420bc83e73
命令解析:
--name:容器名
--p:映射宿主主机端口
-v:挂载宿主目录到容器目录
-e:设置环境变量,此处指定root密码
-d:后台运行容器
查看运行的容器
[root@instance-7tgaowaa ~]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
88784dd4b1fe mysql:5.6 "docker-entrypoint.s…" 4 seconds ago Up 3 seconds 0.0.0.0:3306->3306/tcp mysql
f18fd5277e56 redis "/bin/sh -c 'redis-s…" 44 hours ago Up 44 hours 0.0.0.0:6379->6379/tcp redis
查看本地目录和挂载的目录
[root@instance-7tgaowaa datadir]# pwd
/home/mysql/datadir
[root@instance-7tgaowaa datadir]# ls
auto.cnf ibdata1 ib_logfile0 ib_logfile1 mysql performance_schema
默认情况下,MySQL的启动配置文件是/etc/mysql/my.cnf,而/etc/mysql/conf.d目录下的存在任何.cnf格式的文件时,都会使用该文件中配置项替换默认配置。
增加一个不区分大小写表的参数
[root@instance-7tgaowaa ~]# cd /home/mysql/conf.d/
[root@instance-7tgaowaa conf.d]# cat my.cnf
[mysqld]
lower_case_table_names = 1
然后关掉或者清理掉之前启动的mysql容器
docker rm $(docker ps -a -q)
这个命令慎用,否则会删除之前所有关闭掉后的容器ID
重新启用容器
[root@instance-7tgaowaa ~]# docker run --name mysql -p 3306:3306 -v /home/mysql/datadir:/var/lib/mysql -v /home/mysql/conf.d:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.6
验证是否不区分大小写
查看日志
[root@instance-7tgaowaa conf.d]# docker logs mysql
2018-08-02 07:41:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-08-02 07:41:36 0 [Note] mysqld (mysqld 5.6.41) starting as process 1 ...
2018-08-02 07:41:36 1 [Note] Plugin 'FEDERATED' is disabled.
2018-08-02 07:41:36 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-08-02 07:41:36 1 [Note] InnoDB: The InnoDB memory heap is disabled
时时查看日志信息
[root@instance-7tgaowaa conf.d]# docker logs -f mysql
2018-08-02 07:41:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[/vip]