windows10安装 MySQL 8.0.22

一环境准备：

OS version：windows 10 64位
MySQLversion：MySQL 8.0.22
下载软件包 mysql-8.0.22-winx64.zip
下载地址：https://dev.mysql.com/downloads/mysql/

创建目录结构和文件（解压目录不要包含中文和空格）
D:\MySQL\MySQL-SERVER\mysql-8.0.22-winx64\data
D:\MySQL\MySQL-SERVER\mysql-8.0.22-winx64\logs
D:\MySQL\MySQL-SERVER\mysql-8.0.22-winx64\my.ini
将软件解压至D:\MySQL\MySQL-SERVER\mysql-8.0.22-winx64
配置文件my.ini内容如下：

[client]
port=3308
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

[mysqld]
port=3308
basedir=D:\MySQL\MySQL-SERVER\mysql-8.0.22-winx64
datadir=D:\MySQL\MySQL-SERVER\mysql-8.0.22-winx64\data
log_error=D:\MySQL\MySQL-SERVER\mysql-8.0.22-winx64\logs\mysql-error.log
slow_query_log_file=D:\MySQL\MySQL-SERVER\mysql-8.0.22-winx64\logs\mysql-slow.log
relay_log=D:\MySQL\MySQL-SERVER\mysql-8.0.22-winx64\logs\mysql-relay
lower_case_table_names              = 1
character_set_server            = utf8mb4
collation_server                = utf8mb4_unicode_ci
max_connections                 = 2000
max_connect_errors              = 10000
interactive_timeout             = 600
wait_timeout                    = 600
table_open_cache                = 2048
thread_cache_size               = 51
max_allowed_packet              = 16M
tmp_table_size                  = 256M
max_heap_table_size             = 96M
sort_buffer_size                = 4M
read_buffer_size                = 4M 
join_buffer_size                = 4M
read_rnd_buffer_size            = 8M 
bulk_insert_buffer_size         = 64M
log_timestamps                  = system
slow_query_log                  = 1
long_query_time                 = 1
log_queries_not_using_indexes   = 1
log_throttle_queries_not_using_indexes =10
log_slow_admin_statements       = 1
log_slow_slave_statements       = 1
min_examined_row_limit          = 100
log_queries_not_using_indexes   = 1
log_output                      = FILE

#binlog
server_id                       = 12473306
binlog_expire_logs_seconds      =604800
binlog_format                   = row
max_binlog_size                 = 1024M
max_binlog_cache_size           = 8G
binlog_cache_size               = 4M
sync_binlog                     = 1
master_info_repository          = TABLE
relay_log_info_repository       = TABLE
relay_log_recovery              = ON
log_slave_updates                       = 1

#rep
slave-parallel-type=LOGICAL_CLOCK
slave-parallel-workers=16

#innodb
default-storage-engine         =InnoDB
innodb_page_size                = 16384
innodb_buffer_pool_instances    = 1
innodb_buffer_pool_size         = 1024M
innodb_buffer_pool_dump_pct     = 40
innodb_page_cleaners            = 8
innodb_log_file_size            = 256M
innodb_log_files_in_group       = 2
innodb_log_buffer_size          = 32M
innodb_flush_log_at_trx_commit  = 1
innodb_lock_wait_timeout        = 30
innodb_strict_mode              = 1
innodb_print_all_deadlocks      = 1
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_buffer_pool_dump_pct     = 40
innodb_open_files               = 65536
innodb_file_per_table           = 1
innodb_lock_wait_timeout        = 30
innodb_read_io_threads          = 8
innodb_write_io_threads         = 8
innodb_io_capacity              = 200
innodb_flush_log_at_trx_commit  = 1
innodb_purge_threads            = 4
innodb_max_dirty_pages_pct      = 75
transaction_isolation           = READ-COMMITTED
innodb_page_cleaners            = 16
explicit_defaults_for_timestamp = 1

[mysqldump]
max_allowed_packet                = 16M

二.配置环境变量

新增MYSQL_HOME
MYSQL_HOME=D:\MySQL\MySQL-SERVER\mysql-8.0.22-winx64
添加PATH
D:\MySQL\MySQL-SERVER\mysql-8.0.22-winx64\bin

三.初始化数据库

以管理员身份打开cmd，跳转目录至D:\MySQL\MySQL-SERVER\mysql-8.0.22-winx64
mysqld --initialize-insecure --user=mysql --console

参数说明：
–initialize-insecure 生产空密码
–initialize 生产随机密码

四.MySQL服务：

添加mysql服务
mysqld -install

起停mysql服务
net start mysql
net stop mysql

五.安装如报错：

由于找不到VCRUNtime140_1.dll,无法继续执行代码
由于找不到msvcp140.dll,无法继续执行代码
原因是找不到VCRUNtime140_1.dll（C++ 运行时环境库文件），或者该文件损坏，可以去微软官网下此文件到相应目录,或者去其他电脑拷贝此文件到相应目录。
msvcp140.dll 同理。
文件存放目录问C:\Windows\System32