windows server 2025 安装 MySQL 9

1 软件包下载

MySQL软件包下载：

https://cdn.mysql.com//Downloads/MySQL-9.3/mysql-9.3.0-winx64.zip

windows server 2025镜像下载：

https://software-static.download.prss.microsoft.com/dbazure/888969d5-f34g-4e03-ac9d-1f9786c66749/26100.1.240331-1435.ge_release_amd64fre_SERVER_LOF_PACKAGES_OEM.iso

2 安装开发插件

#报错

#window server 安装MySQL时，已经初始化，但是无法启动，没有日志输出，出现的问题就是因为没有安装以下插件：

VC_redist.x64

下载地址：https://aka.ms/vs/17/release/vc_redist.x64.exe

解释：
vcredist_x64.exe是微软公司Visual C++的运行时库，包含了一些Visual C++的库函数。一般用Visual C++开发的Windows应用程序需要这个运行时库的支持才能在没有安装Visual C++的计算机上正常运行。

安装软件包 .NET Framework.net

打开windows 图标，所有程序，找到---服务器管理器---右上角管理---添加角色和功能---选择左侧竖列功能选项---选中 .NET Framework 3.5  .NET framework 4.8 两个应用程序。
选择下一步安装。

3 MySQL配置

3.1 配置MySQL软件存放目录

软件存放目录到E:\mysql，MySQL软件包解压到mysql目录下

3.2 配置MySQL数据目录

进入mysql目录，创建data文件夹，用于存储MySQL数据。

3.3 配置 MySQL 日志目录

进入mysql目录，创建logs文件夹，用于存储MySQL日志。

3.4 配置 MySQL socket目录

进入mysql目录，创建tmp文件夹，用于存储socket配置文件。

3.5 配置 MySQL pid目录

进入mysql目录，创建pid文件夹，用于存储pid配置文件。

3.6 创建MySQL配置文件

配置文件在线生成网站：https://dbcnf.wlnmp.com

配置文件存放位置：E:\mysql\mysql

MySQL配置文件样例

#my.cnf for MySQL 8.0

[client]

port = 3306

socket = E:\\mysql\\tmp\\mysql.sock

[mysqld]

user = mysql

port = 3306

socket = E:\\mysql\\tmp\\mysql.sock

pid_file = E:\\mysql\\pid\\mysql.pid

basedir = E:\\mysql\\

datadir = E:\\mysql\\data

default_time_zone = +08:00

character_set_server = UTF8MB4

log_timestamps = system

skip_name_resolve = OFF

mysqlx_port = 33060

mysqlx = OFF

slow_query_log = OFF

long_query_time = 3

log_slow_extra = OFF

slow_query_log_file = E:\\mysql\\logs\\mysql_slow_query.log

log_error = E:/mysql/logs/error.log

log_slow_replica_statements = OFF

log_slow_admin_statements = OFF

log_queries_not_using_indexes = OFF

log_throttle_queries_not_using_indexes = 0

min_examined_row_limit = 0

log_error_verbosity = 1

log_error_suppression_list = ""

lock_wait_timeout = 3600

lc-messages-dir=E:\\mysql\\mysql\\share\\

skip-external-locking

max_allowed_packet = 16M

table_open_cache = 1024

table_definition_cache = 1024

sort_buffer_size = 8M

join_buffer_size = 8M

net_buffer_length = 8K

read_buffer_size = 8M

read_rnd_buffer_size = 1M

thread_cache_size = 200

bulk_insert_buffer_size = 16M

tmp_table_size = 32M

performance_schema_max_table_instances = 500

thread_stack = 512K

interactive_timeout = 28800

wait_timeout = 28800

max_heap_table_size = 32M

lower_case_table_names = 1

explicit_defaults_for_timestamp = true

#skip-networking

#bind-address = 127.0.0.1

max_connections = 500

max_connect_errors = 100000

open_files_limit = 65535

sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

# binlog

log_bin = mysql-bin

server_id   = 100

binlog_expire_logs_seconds = 86400

max_binlog_cache_size = 128M

max_binlog_size = 1G

binlog_cache_size = 2M

#master_info_repository = TABLE

#relay_log_info_repository = TABLE

log_replica_updates = ON

# innodb

transaction_isolation = REPEATABLE-READ

default_storage_engine = InnoDB

innodb_buffer_pool_instances = 4

innodb_file_per_table = 1

innodb_data_home_dir = E:\\mysql\\data\\

innodb_data_file_path = ibdata1:64M:autoextend

innodb_log_group_home_dir = E:\\mysql\\data\\

innodb_buffer_pool_size = 10G

innodb_redo_log_capacity = 1G

innodb_log_buffer_size = 32M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50

innodb_read_io_threads = 8

innodb_write_io_threads = 8

innodb_purge_threads = 4

innodb_page_cleaners = 4

innodb_io_capacity = 4000

innodb_io_capacity_max = 8000

innodb_buffer_pool_load_at_startup = ON

innodb_buffer_pool_dump_at_shutdown = ON

#innodb_flush_method = fsync

innodb_print_all_deadlocks = OFF

innodb_print_ddl_logs = OFF

innodb_status_output_locks = OFF

innodb_status_output = OFF

innodb_max_undo_log_size = 1G

innodb_undo_log_truncate = ON

innodb_commit_concurrency = 0

[mysqldump]

quick

[mysql]

prompt = "\u@\h \\R:\\m:\\s [\d]> "

no_auto_rehash

loose-skip-binary-as-hex

[myisamchk]

key_buffer_size = 128M

myisam_sort_buffer_size = 128M

read_buffer = 2M

write_buffer = 2M

注意：Windows下的路径最好配置为双向右斜线，避免出现无法识别路径，产生各种各样的错误。

4 软件安装

进入MySQL bin目录

cd  E:\mysql\mysql\bin

初始化安装MySQL数据库

mysql  --initialize  --console

启动完成，记录用户名和密码

启动mysql 服务

net start mysql

1. 报错信息

mysql -u root -p 登录数据库时，提示：

Error 1130：Host ‘::1’ is not allowed to connect to this MySQL server

解决此方法：

网上好多人都是直接将对应的数据库用户名的host属性改成‘%’，这样其实会降低数据库的访问控制。

遇到这样的问题的时候，还有可能是因为开启了 skip_name_resole=ON ，关闭此功能，把ON改成Off后问题解决。

报错：

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
首次启动MySQL会提示您更改密码，通过以下命令更改密码即可。

#登录MySQL

mysql -u root -p
修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';

FLUSH PRIVILEGES;

EXIT;

重新登录测试一下密码