Windows Server 离线安装 MySQL 8.0.36

https://dev.mysql.com/downloads/mysql/

# D:mysql-8.0.36my.ini
[client]
port = 3306
default-character-set = utf8mb4
 
[mysql]
default-character-set = utf8mb4
 
[mysqld]
port = 3306
basedir = D:mysql-8.0.36
datadir = D:mysql-8.0.36Data
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
default-storage-engine = INNODB
sql-mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
max_connections = 1000
table_open_cache = 2000
table_definition_cache = 1400
tmp_table_size = 64M
max_heap_table_size = 64M
thread_cache_size = 9
myisam_max_sort_file_size = 10G
myisam_sort_buffer_size = 8M
key_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
sort_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 16M
innodb_buffer_pool_size = 4G
innodb_log_file_size = 1G
innodb_thread_concurrency = 8
lower_case_table_names = 1
default-time_zone = '+08:00'

mysqld --defaults-file="D:mysql-8.0.36my.ini" --initialize

mysqld install MySQL --defaults-file="D:mysql-8.0.36my.ini"

net start MySQL

> alter user root@"localhost" identified by "Admin-123";

https://blog.csdn.net/u013008898/article/details/134401542

https://blog.csdn.net/kpacnB_Z/article/details/110122336