docker 安装mysql 5.7
1、
docker rm -f mysql
mkdir -p /www/opt/mysql/log
mkdir -p /www/opt/mysql/data
mkdir -p /www/opt/mysql/conf
cd /www/opt/mysql/conf/
vi my.cnf
[client]
default_character_set=utf8mb4
[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
lower_case_table_names=1
docker run --name mysql57 \
--restart=always -p 3308:3306 \
-v /www/opt/mysql/log:/var/log/mysql \
-v /www/opt/mysql/conf/:/etc/mysql/conf.d \
-v /www/opt/mysql/data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=LhyW115EneT360 \
--privileged=true \
-d mysql:5.7
docker network create -d bridge my-bridge-network
docker network connect my-bridge-network mysql
show variables like '%character%';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
flush privileges;
firewall-cmd --list-ports
firewall-cmd --zone=public --add-port=3306/tcp --permanent && firewall-cmd --reload
firewall-cmd --reload