利用Docker僅花1分鐘時間安裝好MySQL服務

單機版mysql

實戰(zhàn)版：20220519驗證OK

1 、新建mysql容器實例

#docker run -d -p 3306:3306 --privileged=true -v /opt/mysql/log:/var/log/mysql -v /opt/mysql/data:/var/lib/mysql -v /opt/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123.com --name mysql mysql:5.7

2、新建my.cnf

#cd /opt/mysql/conf

#vim my.cnf

[client]

default_character_set=utf8

[mysqld]

collation_server=utf8_general_ci

character_set_server=utf8

3 、重啟啟動Mysql容器查看字符編碼(記得重啟哦)

#docker restart mysql

#docker exec -it mysql /bin/bash

mysql>SHOW VARIABLES LIKE 'character%';（顯示utf8字符集）

4、驗證插入中文字符

mysql>create database db01;

mysql>use db01;

mysql>create table t1(id int,name varchar(20));

mysql>insert into t1 values(1,'zwt');

mysql>insert into t1 values(2,'李四');

驗證成功