docker安装MySQL8

docker run -itd \
-p 13306:3306 \
-v /data/mysql8/data:/var/lib/mysql \
-v /data/mysql8/logs:/var/log/mysql \
-v /data/mysql8/my.cnf:/etc/mysql/conf.d/my.cnf \
-e MYSQL_ROOT_PASSWORD=123456 \
--privileged=true \
--name mysql8-server \
mysql:8.0.35

配置文件：my.cnf 

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4
[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
# 设置mysql客户端默认字符集
default-character-set=utf8mb4
[mysqld]
# 服务端口号 默认3306
port=3306
# 允许访问的IP网段
bind-address=0.0.0.0
# 服务端使用的字符集默认为utf8mb4
character-set-server=utf8mb4
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 数据库字符集对应一些排序等规则
collation-server = utf8mb4_0900_as_cs
#表名忽略大小写
lower_case_table_names=1
#配置连接数
max_connections = 300

创建账号：

-- 创建账号并赋权
CREATE USER 'ymdd'@'%' IDENTIFIED BY '123455';

GRANT ALL PRIVILEGES ON lldd_test.* TO 'ymdd'@'%';

GRANT ALL PRIVILEGES ON lldd_debug.* TO 'ymdd'@'%';

    -- 刷新权限使之生效
FLUSH PRIVILEGES;

-- 修改密码策略mysql_native_password
select user,host,plugin from mysql.user;
use mysql;
ALTER USER 'ymdd'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';