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