docker mysql

docker pull docker.io/mysql:5.7.30

docker run -itd --name mysql \
--privileged=true  \
-p 3306:3306  \
-v /data/mysql:/var/lib/mysql  \
-e MYSQL_ROOT_PASSWORD=123456 \
mysql:5.7.30 \
--character-set-server=utf8mb4 \
--lower_case_table_names=1

–lower_case_table_names=1
mysql数据库表大小写不敏感
--lower_case_table_names=1一定要放在后面

查看数据库表是否大小写敏感

mysql> show variables like '%case%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_file_system | OFF   |
| lower_case_table_names | 1     |
+------------------------+-------+
2 rows in set (0.00 sec)

进入mysql数据查看字符集

还有部分字符集不是utf8
进行配置文件修改：容器的/etc/mysql/mysql.cnf

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
#!includedir /etc/mysql/conf.d/
#!includedir /etc/mysql/mysql.conf.d/

修改后重新启动容器，查看字符集

mysql> show variables like '%character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8mb4                    |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8mb4                    |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.02 sec)