-
拉取镜像
docker pull mysql:8.0.23 -
检查是否拉取成功
docker images -
不挂在本地磁盘建立容器
sudo docker run -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:8.0.23
–name：容器名，此处命名为mysql -e：配置信息，此处配置mysql的root用户的登陆密码 -p：端口映射，此处映射 主机3306端口 到 容器的3306端口 -d：后台运行容器，保证在退出终端后容器继续运行 4. 创建docker mysql 本地磁盘挂在目录,查看docker mysql复制出MySQL 配置文件到本地目录
mkdir -pv /usr/app/docker/mysql/{conf,logs,data,mysql-files}
[root@helpMachine ~]# docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES aab3ae06b416 mysql "docker-entrypoint.s…" 7 days ago Up 32 hours 0.0.0.0:3306->3306/tcp, 33060/tcp mysqlJiang
docker cp aab3ae06b416:/etc/mysql/my.cnf /usr/app/docker/mysql/conf
5.创建docker 容器
docker run -d \ --name mysqlJiang \ --restart=always \ --net mynetwork \ --ip 172.18.0.6 \ -p 3306:3306 \ -v /usr/app/docker/mysql/conf:/etc/mysql/conf.d \ -v /usr/app/docker/mysql/logs:/var/log/mysql \ -v /usr/app/docker/mysql/data:/var/lib/mysql \ -v /usr/app/docker/mysql/mysql-files:/var/lib/mysql-files/ \ -e MYSQL_ROOT_PASSWORD=root \ -d mysql
[root@helpMachine docker]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
aab3ae06b416 mysql "docker-entrypoint.s…" 5 seconds ago Up 3 seconds 0.0.0.0:3306->3306/tcp, 33060/tcp mysqlJiang
8529d3995214 canal/canal-server "/alidata/bin/main.s…" 2 days ago Up 2 days 9100/tcp, 11110/tcp, 11112/tcp, 0.0.0.0:11111->11111/tcp canal-server
0c4f31737d22 probablyfine/flume:2.0.0 "start-flume" 6 days ago Up 2 days flume-test
9f0ac325b356 apachepulsar/pulsar-dashboard "/pulsar/start.sh" 6 days ago Up 2 days 0.0.0.0:8081->80/tcp apachePulsar-dashboard
9f75b7f33707 apachepulsar/pulsar:2.4.2 "bin/pulsar standalo…" 6 days ago Up 2 days 0.0.0.0:6650->6650/tcp, 0.0.0.0:8080->8080/tcp vigilant_lewin
[root@helpMachine docker]# docker logs -f aab3ae06b416
2021-03-25 01:51:56+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.23-1debian10 started.
2021-03-25 01:51:56+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2021-03-25 01:51:56+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.23-1debian10 started.
2021-03-25 01:51:56+00:00 [Note] [Entrypoint]: Initializing database files
mysqld: [Warning] Skipping '!includedir /etc/mysql/conf.d/' directive as maximum include recursion level was reached in file /etc/mysql/conf.d/my.cnf at line 32.
2021-03-25T01:51:56.822816Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.23) initializing of server in progress as process 43
2021-03-25T01:51:56.832556Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-03-25T01:51:57.708923Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-03-25T01:51:59.282302Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2021-03-25 01:52:02+00:00 [Note] [Entrypoint]: Database files initialized
2021-03-25 01:52:02+00:00 [Note] [Entrypoint]: Starting temporary server
mysqld: [Warning] Skipping '!includedir /etc/mysql/conf.d/' directive as maximum include recursion level was reached in file /etc/mysql/conf.d/my.cnf at line 32.
2021-03-25T01:52:03.165377Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23) starting as process 88
2021-03-25T01:52:03.307737Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-03-25T01:52:03.974253Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-03-25T01:52:04.135265Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2021-03-25T01:52:04.322587Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-03-25T01:52:04.322787Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-03-25T01:52:04.324137Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2021-03-25T01:52:04.345179Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.23' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
2021-03-25 01:52:04+00:00 [Note] [Entrypoint]: Temporary server started.
mysql: [Warning] Skipping '!includedir /etc/mysql/conf.d/' directive as maximum include recursion level was reached in file /etc/mysql/conf.d/my.cnf at line 32.
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
mysql: [Warning] Skipping '!includedir /etc/mysql/conf.d/' directive as maximum include recursion level was reached in file /etc/mysql/conf.d/my.cnf at line 32.
2021-03-25 01:52:09+00:00 [Note] [Entrypoint]: Stopping temporary server
mysqladmin: [Warning] Skipping '!includedir /etc/mysql/conf.d/' directive as maximum include recursion level was reached in file /etc/mysql/conf.d/my.cnf at line 32.
2021-03-25T01:52:09.566311Z 10 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.23).
2021-03-25T01:52:10.865083Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23) MySQL Community Server - GPL.
2021-03-25 01:52:11+00:00 [Note] [Entrypoint]: Temporary server stopped
2021-03-25 01:52:11+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
mysqld: [Warning] Skipping '!includedir /etc/mysql/conf.d/' directive as maximum include recursion level was reached in file /etc/mysql/conf.d/my.cnf at line 32.
2021-03-25T01:52:11.844977Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23) starting as process 1
2021-03-25T01:52:11.854103Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-03-25T01:52:12.367605Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-03-25T01:52:12.545614Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2021-03-25T01:52:12.675237Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-03-25T01:52:12.675468Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-03-25T01:52:12.679057Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2021-03-25T01:52:12.700492Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.23' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
[root@helpMachine docker]# docker exec -it aab3ae06b416 /bin/bash
root@aab3ae06b416:/#
root@aab3ae06b416:/#
root@aab3ae06b416:/# mysql -uroot -proot
mysql: [Warning] Skipping '!includedir /etc/mysql/conf.d/' directive as maximum include recursion level was reached in file /etc/mysql/conf.d/my.cnf at line 32.
mysql: [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 17
Server version: 8.0.23 MySQL Community Server - GPL
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
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> select host,user,plugin,authentication_string from mysql.user;
+-----------+------------------+-----------------------+------------------------------------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+------------------+-----------------------+------------------------------------------------------------------------+
| % | canal | mysql_native_password | *E3619321C1A937C46A0D8BD1DAC39F93B27D4458 |
| % | root | caching_sha2_password | $A$005$b2;o~`65U|napE>L.QjY2XLddFrUT/uqRciIsI5zEACo3jQS2AGzHYwC8XA07 |
| localhost | mysql.infoschema | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| localhost | mysql.session | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| localhost | mysql.sys | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| localhost | root | caching_sha2_password | $A$005$
e" }x/3T^;!y%
rB10XeOqUv0P.T8CcjwhoFOhF.Y2D.Ol2U.ZdIA0v39 |
+-----------+------------------+-----------------------+------------------------------------------------------------------------+
6 rows in set (0.08 sec)
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
Query OK, 0 rows affected (0.00 sec)
mysql>
