Docker使用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]