docker 安装MySQL5.6

安装

docker pull mysql5.6

docker images

➜  ~ docker images                 
REPOSITORY                                      TAG                 IMAGE ID            CREATED             SIZE
docker.io/mysql                                 5.6                 c580203d8753        2 weeks ago         302 MB

启动

（第一次启动Docker-MySql主要是查看Docker里面MySQL的默认配置，数据位置，日志位置，配置文件位置）

docker run -it --entrypoint /bin/bash --rm mysql:5.6

命令解释

（创建并进入容器里，方便查看容器里面的默认设置，–rm参数表示退出容器会自动删除当前容器）

cat /etc/mysql/mysql.cnf (查看默认配置文件)

....... 主要有下面
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/

退出

再启动

docker run -d --name mysql -p 13306:3306 --env MYSQL_ROOT_PASSWORD=123456 mysql:5.6 --character-set-server=utf8 --collation-server=utf8_unicode_ci

设置空密码 这样root就是空密码了

docker run -d --name mysql -p 13306:3306 --env MYSQL_ALLOW_EMPTY_PASSWORD=root mysql:5.6 --character-set-server=utf8 --collation-server=utf8_unicode_ci

在宿主机上链接

mysql -u root -h 127.0.0.1 -P 13306 -p

➜   mysql -u root -h 127.0.0.1 -P 13306 -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.50 MySQL Community Server (GPL)

Copyright (c) 2000, 2020, 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.