docker-compose-安装mysql8.4.2(linux/windows)

一、linux中mysql8.4.2

1、首先安装docker与docker-compose，这里不再说明

2、拉取mysql8.4.2

        docker pull mysql:8.4.2

4、创建目录

        mkdir /opt/mysql842/{data,logs,conf,mysql-files} -p

5、vi /opt/mysql842/conf/my.cnf

输入下面内容保存

[client]
character_set_client=utf8mb4
[mysqld]
log_bin=ON
log-error=/var/log/mysqld.log
character_set_server=utf8mb4
collation_server=utf8mb4_general_ci
init_connect='SET NAMES utf8mb4'
authentication_policy=mysql_native_password
#最大连接数
max_connections=4000
#最大错误连接数
max_connect_errors=8000
log_bin_trust_function_creators=1
general_log=OFF
general_log_file=/var/log/mysqld.log
slow_query_log=ON
slow_query_log_file=/var/log/mysqld-slow.log
innodb_open_files=10000
open_files_limit=10000
# 解决排序问题，mysql5.7以上默认开启了ONLY_FU