CentOS8-Docker安装MySQL8

查看官方文档

$ docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag

-

• 启动5.7（未测试，我想装8）

[root@swl123 ~]# docker run -d -p 3310:3306 -v /home/mysql/conf:/etc/mysql/conf.d -v /home/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root --name mysql3310 mysql:5.7

• 启动8.0.26
• 1. 学会使用–help，这里使用8.0.26版本，显示的属性都是可以在命令行后进行添加
• -MySQL8一般要设置区分表名大小写以及密码策略
• -通过help命令知道区分表大小写lower_case_table_names可以在启动时添加

docker run -it --rm mysql:8.0.26 --verbose --help

• 2. 整理启动命令，添加–lower_case_table_names=1，–skip_name_resolve=no：关闭dns解析，这样外网访问数据库会快点

[root@swl123 ~]# docker run -p 3388:3306 -v /home/mysql/conf:/etc/mysql/conf.d -v /home/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -d --name mysql8 mysql:8.0.26 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci --lower_case_table_names=1 --skip_name_resolve=no

• 3.有惊无险的启动了， 进入容器

[root@swl123 ~]# docker run -p 3388:3306 -v /home/mysql/conf:/etc/mysql/conf.d -v /home/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -d --name mysql8 mysql:8.0.26 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci --lower_case_table_names=1
612eaf5c2777b8ce3d54f0073d437d3e0d4a3ecba0ca57c7c49a6cc71f5b7054
[root@swl123 ~]# docker ps
CONTAINER ID   IMAGE                  COMMAND                  CREATED         STATUS         PORTS                                                                                  NAMES
612eaf5c2777   mysql:8.0.26           "docker-entrypoint.s…"   3 minutes ago   Up 3 minutes   33060/tcp, 0.0.0.0:3388->3306/tcp, :::3388->3306/tcp                                   mysql8
c6a750b3039f   portainer/portainer    "/portainer"             4 hours ago     Up 4 hours     0.0.0.0:8088->9000/tcp, :::8088->9000/tcp                                              portainer
34fb3c029026   elasticsearch:7.13.3   "/bin/tini -- /usr/l…"   5 hours ago     Up 5 hours     0.0.0.0:9200->9200/tcp, :::9200->9200/tcp, 0.0.0.0:9300->9300/tcp, :::9300->9300/tcp   elasticsearch02
[root@swl123 ~]# docker exec -it 612eaf5c2777 /bin/bash
root@612eaf5c2777:/# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.26 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> use
ERROR: 
USE must be followed by a database name
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> 

不能远程访问请设置服务器的防火墙，Linux的防火墙
/开启6379端口
firewall-cmd --zone=public --add-port=6379/tcp --permanent
//检查端口是否开启
firewall-cmd --query-port=6379/tcp
//重启防火墙
firewall-cmd --reload

• 很奇怪，不用再设置密码策略，远程也可以连接，那就测试表名大小写问题：

• 没问题就可以愉快的用数据库了
• 此博客是边写边安装，确实没有遇到想象中的一些问题，很奇怪