Hellojxl - windows
type: channel
link: https://hellojxl.com/index.php/tag/windows/
items: Windows下多版本MySQL的安装

Windows下多版本MySQL的安装
type: item
date: 2025-12-08T10:36:00+00:00
description: 前言最近由于等保相关问题以及本地开发的需要，需同时安装多个版本的MySQL，因此只能根据zip进行手动安装，期间遇到一些问题，在此记录一下。手动安装过程首先从官网下载zip格式的压缩包，并解压到向安装的目录在安装目录新建一个my.ini配置文件，文件内容如下，大部分是默认配置(log相关名称已改)，可按自己需要修改。 --------太长已折叠，点击查看具体配置-------[mysql] no-beep default-character-set=utf8mb4 # SERVER SECTION # ---------------------------------------------------------------------- # # The following options will be read by the MySQL Server. Make sure that # you have installed the server correctly (see above) so it reads this # file. # # server_type=3 [mysqld] # The next three options are mutually exclusive to SERVER_PORT below. # skip-networking # enable-named-pipe # shared-memory # shared-memory-base-name=MYSQL # The Pipe the MySQL Server will use. # socket=MYSQL # The access control granted to clients on the named pipe created by the MySQL Server. # named-pipe-full-access-group= # The TCP/IP Port the MySQL Server will listen on port=3306 tls_version=TLSv1.2,TLSv1.3 innodb_force_recovery=0 # Path to installation directory. All paths are usually resolved relative to this. basedir="D:/dev/mysql/" # Path to the database root datadir=D:/dev/mysql/Data # The default character set that will be used when a new schema or table is # created and no character set is defined # character-set-server= # Administers multifactor authentication (MFA) capabilities. It applies to the authentication # factor-related clauses of CREATE USER and ALTER USER statements used to manage MySQL account # definitions, where “factor” corresponds to an authentication method or plugin associated # with an account. authentication_policy=*,, # The default storage engine that will be used when create new tables when default-storage-engine=INNODB # The current server SQL mode, which can be set dynamically. # Modes affect the SQL syntax MySQL supports and the data validation checks it performs. This # makes it easier to use MySQL in different environments and to use MySQL together with other # database servers. sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZER…