【MySQL8.0.32安装】Windows Server2019安装MySQL8.0.32

• 安装包下载：

https://downloads.mysql.com/archives/community/

下载mysql-8.0.32-winx64.zip

• 1、制定目录配置

basedir=D:\\mysql8.0.32
#mysql数据存放目录
datadir=D:\\mysql8.0.32\\data

将.zip压缩包解压到D盘，并重命名为mysql8.0.32

• 2、编辑my.ini文件

[client]
#max_allowed_packet=32M
# pipe
# socket=0.0
port=3306
[mysql]
no-beep
#max_allowed_packet=32M
default-character-set=utf8

[mysqld]
max_allowed_packet=256M
interactive_timeout=31536000
wait_timeout=300
group_concat_max_len=102400
early-plugin-load=keyring_file.dll

keyring_file_data=D:/mysql-8.0.32/data
#关闭SSL
skip-ssl
plugin-load=validate_password.dll
validate_password_policy=1
validate-password=FORCE_PLUS_PERMANENT
validate_password_number_count=1
validate_password_special_char_count=1

plugin-load-add=connection_control.dll
connection-control=FORCE_PLUS_PERMANENT
connection-control-failed-login-attempts=FORCE_PLUS_PERMANENT
connection_control_failed_connections_threshold=10

port=3306
character-set-server=utf8mb4
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
basedir="D:/mysql-8.0.32/"

# Path to the database root
datadir="D:/mysql-8.0.32/data/"
innodb_data_home_dir="D:/mysql-8.0.32/data/"
innodb_data_file_path=ibdata1:10M:autoextend
innodb_log_group_home_dir="D:/mysql-8.0.32/data/"
innodb_file_per_table=1

log-error="D:/mysql-8.0.32/logs/mysql.err"
pid-file="D:/mysql-8.0.32/tmp/mysql.pid"
#socket="D:/mysql-8.0.32/tmp/mysql.socket"

# General and Slow logging.
#log-output=FILE
#general-log=1
#general_log_file="mysqlgenaral.log"
#slow-query-log=1
#slow_query_log_file="mysqlslow.log"
#long_query_time=3

# Server Id.
server-id=33061
# Binary Logging.
log-bin="D:/mysql-8.0.32/logs/mysql-bin"
binlog_format=row
expire_logs_days=7
log_bin_trust_function_creators=on
max_connections=2000
max_connect_errors=1000
query_cache_size=0
query_cache_type=0
table_open_cache=2048
tmp_table_size=203M
thread_cache_size=32
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=395M
key_buffer_size=64M
read_buffer_size=8M
read_rnd_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=16M

innodb_buffer_pool_size=10G
innodb_log_file_size=512M
innodb_thread_concurrency=16
innodb_autoextend_increment=64
innodb_buffer_pool_instances=8
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
innodb_open_files=300
innodb_stats_on_metadata=0
innodb_checksum_algorithm=0
back_log=80
flush_time=0
join_buffer_size=16M
open_files_limit=4161

sort_buffer_size=16M
table_definition_cache=1400

binlog_row_event_max_size=8K

• 3、这里采用管理员用户administrator进行安装

D:/mysql-8.0.32/bin/mysqld --initialize

D:/mysql-8.0.32/bin/net start mysql

初始化输入这个命令可以查看初始密码  mysqld --initialize --console
net start mysql 可能失败。

 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';