1、下载MySQL

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

2、安装MySQL 8.0(服务器配置:4核/8G内存/100G硬盘)

  (1)解压到D盘

  (2)编写配置文件

# D:\mysql-8.0.36\my.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.36\Data
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'

  (3)初始化MySQL(进入D:\mysql-8.0.36\bin目录并在当前目录下打开命令提示符窗口)

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

  (4)创建服务

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

  (5)启动MySQL服务

net start MySQL

  (6)使用临时密码登录后,更新root密码

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

3、Server 2012安装报错

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

4、C++ 2019安装

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

  

posted on 2024-03-18 11:37  a120608yby  阅读(105)  评论(0编辑  收藏  举报