Docker安装Mysql5.7.44

前置条件：Linux服务器上必须安装好Docker

• 执行下述命令，拉取mysql5.7.44镜像 创建容器

docker run \
-p 3305:3306 \
--name mysql5 \
--privileged=true \
--privileged=true \
--restart=unless-stopped \
-v /docker/mysql5.7.44/mysql:/etc/mysql/conf.d \
-v /docker/mysql5.7.44/logs:/logs \
-v /docker/mysql5.7.44/data:/var/lib/mysql \
-v /etc/localtime:/etc/localtime \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:5.7.44

• 进入容器

docker exec -it mysql5 /bin/bash

• 修改root密码

alter user 'root'@'localhost' identified by 'mysql555';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql555';
#刷新权限
flush privileges;

• 大小写不区分

[mysqld]
lower_case_table_names = 1

• 新建用户和数据库

CREATE DATABASE IF NOT EXISTS meteor DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
create user 'meteor'@'%' identified by '1qazmeteor2022';
#授予用户qddr通过外网IP对数据库“qddr”的全部权限
grant all on meteor.* to 'meteor'@'%' identified by '1qazmeteor2022'; 
#刷新权限
flush privileges;