简介如何在Windows 中搭建一个MySQL

MySQL 安装包

1.MySQL 下载目录 2.Windows MySQL Installer

第一步:是否为第一次安装

第一次安装

直接双击程序开始安装就行

非第一次安装

完全卸载该软件的办法：

1.第一步，进入…控制面板\程序\程序和功能，卸载下图中的MySQL两个软件

2.第二步，删除上次安装目录的MySQL残留文件，更不要忘了删除ProgramData下的MySQL文件夹，如下图所示。注意：这里的文件夹与上次安装目录里的残留文件不同，C:\ProgramData 一般默认是隐藏的,或者在你上一次自定义安装的文件目录

3.第三步，Win+R 输入 regedit 运行，进入注册表编辑器，按下图路径，找到MySQL，进而删除MySQL注册表信息==注意不要删除错误了==。

4.第四步，做完前三步，打开服务，会发现MySQL80服务依然存在，如下图所示。这就是导致安装失败的重要原因，所以需要删除MySQL80服务。方法：以管理员的权限运行dos命令，然后输入 sc delete MySQL80。

	 sc delete MySQL80 (自己MySQL的服务名称)
	 [SC] DeleteService 成功

查看任务管理器 服务 中的mysql 服务已消失 ==建议重启电脑后再进行新的安装操作==

安装教程

借鉴的菜鸟上面的安装步骤: Windows10 MYSQL Installer 安装（mysql-installer-community-5.7.19.0.msi）

1.下载对应的 Windows MySQL Installer

2.双击执行

之后出现如下图选择安装类型.这里我选择的 Custom(自定义)

Choosing a Setup Type

点击下一步:

Select Products

在这个页面选择我们需要的产品,

我这里只需要 MySQL Servers 点击 + 展开选择对应的产品;

点击绿色箭头将其添加至 Products To Be Installed 中;如果你想安装其他的产品也需要将其选择添加

修改安装路径

添加后如果你需要修改安装路径 ,点击 已在 Products To Be Installed 中的产品 点击后会在 右下角反向出现 * Advanced Options* 点击它.出现 弹出框可进行产品的安装路径修改 ==建议文件夹名一致,以便后期寻找==

默认路径: Install Directory(安装目录): C:\Program Files\MySQL\MySQL Server 8.0

Data Directory(数据目录): C:\ProgramData\MySQL\MySQL Server 8.0

进行修改成自己想要安装的路径: 点击确认后会出现询问框,点击OK

点击下一步:

Path Conflicts

Path Conflicts (路径冲突) :出现的原因是我们已经创建了安装的文件路径,他会提示你, 您可以使用相同的文件夹或将其更改为一个新的文件夹，请记住，安装过程可以覆盖已经存在的文件夹。

点击下一步: 出现询问框点击 YES 继续

 <!-- 翻译询问框内容 -->
 您选择的路径仍然会有警告。您确定要继续吗?

点击下一步:

Installation

Installation(安装) : 根据提示点击 execute,会将你前面选择的产品进行安装 安装完成后:

点击下一步:

Product Configuration

Product Configuration(产品配置):此页面会展示你需要配置那些产品 点击下一步:

Type and Networking

Type and Networking(类型和网络):一般我们不会更改上面的配置选项 ,==如果您要更改请确认你知晓该属性作用== ,这里我们如果有需要可以将 Show Advanced and Logging Options(显示高级和日志记录选项) 勾选上,方便我们后面查看一些日志信息.

Logging Options ,Advanced Options

勾选后: 左侧菜单列表多出 Logging Options ,Advanced Options 选项 点击下一步

Authentication Method

Authentication Method(身份验证方法): 翻译:

MySQL 8支持一种新的认证方法，基于改进的更强的基于sha256的密码方法。建议今后所有新的
MySOL Server安装都使用这种方法。注意:服务器端这个新的认证插件需要新版本的连接器和客户端支持
这个新的8.0默认认证缓存sha2密码认证)。目前使用libmysglclient 8.0的MySQL 8.0连接器和社区驱动
程序支持这个新方法。如果客户端和应用程序不能更新以支持这种新的身份验证方法，
MySQL 8.0服务器可以配置为使用下面的遗留的MySQL身份验证方法。

使用旧的认证方法(保留MySQL 5。x兼容性)使用旧MySQL如果应用程序不能更新到使用启用了MySQL 8的连接器和驱动程序，
则不能重新编译现有的应用程序。安全指南:如果可能，我们强烈建议采取必要步骤，将应用程序、库和数据库服务器升级为新的更强的身份验证。
这个新方法将显著提高您的安全性

这里我们选择第一个选项 点击下一步:

Accounts and Roles

Accounts and Roles(账号和角色):在这个页面设置您的密码/添加角色 ==注意:在此处新增 MySQL User Accounts 可能导致后面安装程序的异常== 输入密码:

点击下一步:

Windows Service

Windows Service(服务):配置您的Windows 上的MySQL 服务,由于前面已经有过一个MySQL 的名称了,建议使用默认值 MySQL80; 建议勾选上 Start the MySQL Server at System Startup(在系统启动时启动MySQL服务器) Run Windows Service as ... 建议勾选 Standard System Account(标准系统帐户) 点击下一步:

Logging Options

如果没有在前面勾选 Show Advanced and Logging Options 会进入到 (==Apply Configuration(应用配置)==) Logging Options(日志记录选项): 1.这里会是安装时候日志文件放置的位置,建议改变到自己了解的地方,方便有错误进行查看(建议只改变文件路径不修改文件名哦!) 点击下一步:

Advanced Options

Advanced Options(高级选项):这里我们一般点击默认
点击下一步:

Apply Configuration

Apply Configuration(应用配置): 点击 Execute(执行)
==出现问题, 卡在 Starting the server (并不是所有都会出现这个问题)== 对应解决方案: 任务管理器 -- > 打开服务 --> 搜索MySQL80(你的mysql服务) --> 右键属性 -->登录 -->选择本地账户 -->应用 -->确认 -->再次执行 Execute 执行结果: 点击finish(完成):

Product Configuration

Product Configuration(产品配置): 点击下一步:

Installation Complete

Installation Complete(安装完成): 1.点击 Copy Log to Clipboard (复制日志到剪贴板) 查看安装日志:

example(日志举例):

1: Action 13:33:38: INSTALL. 
1: 1: MySQL Server 8.0 2: {2C2F1723-07EB-4750-98AF-B3E74CD48E7E} 
1: Action 13:33:38: FindRelatedProducts. Searching for related applications
1: Action 13:33:38: AppSearch. Searching for installed applications
1: Action 13:33:38: DwordToNumber. 
1: Action 13:33:38: LaunchConditions. Evaluating launch conditions
1: Action 13:33:38: ValidateProductID. 
1: Action 13:33:38: CostInitialize. Computing space requirements
1: Action 13:33:38: FileCost. Computing space requirements
1: Action 13:33:38: CostFinalize. Computing space requirements
1: Action 13:33:38: MigrateFeatureStates. Migrating feature states from related applications
1: Action 13:33:38: InstallValidate. Validating install
1: Action 13:33:39: SaveTargetDir. 
1: Action 13:33:39: InstallInitialize. 
1: Action 13:33:39: SetQtRemoveService. 
1: Action 13:33:39: RemoveExistingProducts. Removing applications
1: Action 13:33:39: ProcessComponents. Updating component registration
1: Action 13:33:39: GenerateScript. Generating script operations for action:
1: Updating component registration
1: Action 13:33:40: UnpublishFeatures. Unpublishing Product Features
1: Action 13:33:40: RemoveRegistryValues. Removing system registry values
1: Action 13:33:40: RemoveShortcuts. Removing shortcuts
1: Action 13:33:40: RemoveFiles. Removing files
1: Action 13:33:40: InstallFiles. Copying new files
1: File: Copying new files,  Directory: ,  Size: 
1: Action 13:33:40: CreateShortcuts. Creating shortcuts
1: Shortcut: Creating shortcuts
1: Action 13:33:40: WriteRegistryValues. Writing system registry values
1: Key: Writing system registry values, Name: , Value: 
1: Action 13:33:41: RegisterUser. Registering user
1: Action 13:33:41: RegisterProduct. Registering product
1: Registering product
1: Action 13:33:41: PublishFeatures. Publishing Product Features
1: Feature: Publishing Product Features
1: Action 13:33:41: PublishProduct. Publishing product information
1: Action 13:33:41: InstallFinalize. 
1: Action 13:33:41: ProcessComponents. Updating component registration
1: Action 13:33:41: InstallFiles. Copying new files
1: File: harness-library.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 686080
1: File: ibd2sdi.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6383392
1: File: innochecksum.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6377256
1: File: libcrypto-1_1-x64.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 2863616
1: File: libmecab.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 1839616
1: File: libprotobuf.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 2835968
1: File: libprotobuf.lib,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 4179030
1: File: libprotobuf-debug.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 5856768
1: File: libprotobuf-lite.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 554496
1: File: libprotobuf-lite.lib,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 898420
1: File: libprotobuf-lite-debug.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 1161728
1: File: libssl-1_1-x64.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 686080
1: File: lz4_decompress.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6321968
1: File: my_print_defaults.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6254384
1: File: myisam_ftdump.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6513968
1: File: myisamchk.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6638368
1: File: myisamlog.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6482216
1: File: myisampack.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6535976
1: File: mysql.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6960408
1: File: mysql_config_editor.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6269752
1: File: mysql_migrate_keyring.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6935352
1: File: mysql_secure_installation.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6844232
1: File: mysql_ssl_rsa_setup.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6293816
1: File: mysql_tzinfo_to_sql.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6208824
1: File: mysql_upgrade.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6933288
1: File: mysqladmin.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6854952
1: File: mysqlbinlog.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 7168808
1: File: mysqlcheck.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6859048
1: File: mysqld.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 52380448
1: File: mysqld_multi.pl,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 28776
1: File: mysqldump.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6925600
1: File: mysqldumpslow.pl,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 7881
1: File: mysqlharness_stdx.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 34104
1: File: mysqlharness_tls.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 62256
1: File: mysqlimport.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6847784
1: File: mysqlpump.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 7319328
1: File: mysqlrouter.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 7488296
1: File: mysqlrouter_http.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 267056
1: File: mysqlrouter_http_auth_backend.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 101712
1: File: mysqlrouter_http_auth_realm.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 31560
1: File: mysqlrouter_io_component.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 73536
1: File: mysqlrouter_keyring.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 7540536
1: File: mysqlrouter_passwd.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 7513400
1: File: mysqlrouter_plugin_info.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6236992
1: File: mysqlshow.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6846248
1: File: mysqlslap.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6863648
1: File: perror.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 7062304
1: File: zlib_decompress.exe,  Directory: D:\tool\Mysql\MySQL Server 8.0\bin\,  Size: 6230320
1: File: ChangeLog,  Directory: D:\tool\Mysql\MySQL Server 8.0\docs\,  Size: 22
1: File: INFO_SRC,  Directory: D:\tool\Mysql\MySQL Server 8.0\docs\,  Size: 188
1: File: sample_mysqlrouter.conf,  Directory: D:\tool\Mysql\MySQL Server 8.0\docs\,  Size: 2213
1: File: mysqlrouter.conf.sample,  Directory: D:\tool\Mysql\MySQL Server 8.0\etc\,  Size: 1672
1: File: errmsg.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\,  Size: 5569
1: File: field_types.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\,  Size: 3169
1: File: my_command.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\,  Size: 4365
1: File: my_compress.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\,  Size: 3646
1: File: my_list.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\,  Size: 2165
1: File: mysql.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\,  Size: 32931
1: File: client_plugin.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\mysql\,  Size: 7567
1: File: mysql_com.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\,  Size: 36164
1: File: plugin_auth_common.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\mysql\,  Size: 6544
1: File: mysql_time.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\,  Size: 3554
1: File: udf_registration_types.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\mysql\,  Size: 3827
1: File: mysql_version.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\,  Size: 1120
1: File: mysqld_error.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\,  Size: 244252
1: File: mysqlx_ername.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\,  Size: 7304
1: File: mysqlx_error.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\,  Size: 4211
1: File: mysqlx_version.h,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\,  Size: 1840
1: File: applink.c,  Directory: D:\tool\Mysql\MySQL Server 8.0\include\openssl\,  Size: 3508
1: File: http_auth_backend.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 7494656
1: File: http_auth_realm.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 7494144
1: File: http_server.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 7589376
1: File: io.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 7488000
1: File: keepalive.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 19456
1: File: libmysql.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 6827520
1: File: libmysql.lib,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 29650
1: File: libprotobuf-lite.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 554496
1: File: libprotobuf-lite.lib,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 898420
1: File: char.bin,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp\,  Size: 262496
1: File: dicrc,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp\,  Size: 693
1: File: left-id.def,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp\,  Size: 55910
1: File: matrix.bin,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp\,  Size: 3463716
1: File: pos-id.def,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp\,  Size: 1477
1: File: rewrite.def,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp\,  Size: 6241
1: File: right-id.def,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp\,  Size: 55910
1: File: sys.dic,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp\,  Size: 37779919
1: File: unk.dic,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp\,  Size: 5409
1: File: char.bin,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis\,  Size: 262496
1: File: dicrc,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis\,  Size: 693
1: File: left-id.def,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis\,  Size: 55910
1: File: matrix.bin,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis\,  Size: 3463716
1: File: pos-id.def,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis\,  Size: 1477
1: File: rewrite.def,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis\,  Size: 6241
1: File: right-id.def,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis\,  Size: 55910
1: File: sys.dic,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis\,  Size: 37635899
1: File: unk.dic,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis\,  Size: 5409
1: File: char.bin,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8\,  Size: 262496
1: File: dicrc,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8\,  Size: 693
1: File: left-id.def,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8\,  Size: 55910
1: File: matrix.bin,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8\,  Size: 3463716
1: File: pos-id.def,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8\,  Size: 1477
1: File: rewrite.def,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8\,  Size: 6241
1: File: right-id.def,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8\,  Size: 55910
1: File: sys.dic,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8\,  Size: 49199027
1: File: unk.dic,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8\,  Size: 5690
1: File: mecabrc,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\mecab\etc\,  Size: 1382
1: File: metadata_cache.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 8297472
1: File: mysqlclient.lib,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 43934588
1: File: mysqlharness_stdx.lib,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 10026
1: File: mysqlharness_tls.lib,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 23120
1: File: mysqlrouter_http.lib,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 45804
1: File: mysqlrouter_http_auth_backend.lib,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 47760
1: File: mysqlrouter_http_auth_realm.lib,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 11770
1: File: mysqlrouter_io_component.lib,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 12642
1: File: mysqlrouter_lib.lib,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 21061864
1: File: adt_null.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 25600
1: File: component_audit_api_message_emit.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 24576
1: File: component_keyring_file.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 1117696
1: File: component_log_filter_dragnet.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 31744
1: File: component_log_sink_json.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 36352
1: File: component_log_sink_syseventlog.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 17920
1: File: component_mysqlbackup.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 37888
1: File: component_query_attributes.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 14336
1: File: component_reference_cache.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 45568
1: File: component_validate_password.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 59904
1: File: connection_control.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 43520
1: File: ddl_rewriter.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 69120
1: File: group_replication.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 1721344
1: File: ha_example.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 30720
1: File: ha_mock.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 39424
1: File: keyring_file.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 91648
1: File: keyring_udf.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 25600
1: File: libpluginmecab.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 29184
1: File: locking_service.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 13824
1: File: mypluglib.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 14336
1: File: mysql_clone.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 129536
1: File: mysql_no_login.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 12288
1: File: rewrite_example.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 13312
1: File: rewriter.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 56320
1: File: semisync_master.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 77312
1: File: semisync_replica.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 34304
1: File: semisync_slave.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 34816
1: File: semisync_source.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 76288
1: File: validate_password.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 47616
1: File: version_token.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\plugin\,  Size: 49664
1: File: rest_api.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 7537152
1: File: rest_metadata_cache.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 7550464
1: File: rest_router.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 7525376
1: File: rest_routing.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 7568384
1: File: router_openssl.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 11776
1: File: router_protobuf.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 11776
1: File: routing.dll,  Directory: D:\tool\Mysql\MySQL Server 8.0\lib\,  Size: 7957504
1: File: LICENSE,  Directory: D:\tool\Mysql\MySQL Server 8.0\,  Size: 276551
1: File: LICENSE.router,  Directory: D:\tool\Mysql\MySQL Server 8.0\,  Size: 47658
1: File: README,  Directory: D:\tool\Mysql\MySQL Server 8.0\,  Size: 666
1: File: README.router,  Directory: D:\tool\Mysql\MySQL Server 8.0\,  Size: 679
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\bulgarian\,  Size: 342405
1: File: armscii8.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 5961
1: File: ascii.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 5947
1: File: cp1250.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 8676
1: File: cp1251.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 8762
1: File: cp1256.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 6010
1: File: cp1257.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 9343
1: File: cp850.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 5947
1: File: cp852.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 5963
1: File: cp866.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 6054
1: File: dec8.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 6970
1: File: geostd8.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 5957
1: File: greek.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 6169
1: File: hebrew.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 5952
1: File: hp8.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 5943
1: File: Index.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 19474
1: File: keybcs2.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 5970
1: File: koi8r.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 5951
1: File: koi8u.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 6973
1: File: latin1.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 10251
1: File: latin2.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 7673
1: File: latin5.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 5950
1: File: latin7.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 7879
1: File: macce.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 8488
1: File: macroman.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 8499
1: File: README,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 1749
1: File: swe7.xml,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\charsets\,  Size: 6971
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\czech\,  Size: 342327
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\danish\,  Size: 342327
1: File: dictionary.txt,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\,  Size: 25575
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\dutch\,  Size: 343347
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\english\,  Size: 341568
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\estonian\,  Size: 341832
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\french\,  Size: 342975
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\german\,  Size: 349220
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\greek\,  Size: 348359
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\hungarian\,  Size: 342209
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\italian\,  Size: 343338
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\japanese\,  Size: 349014
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\korean\,  Size: 344608
1: File: messages_to_clients.txt,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\,  Size: 610894
1: File: messages_to_error_log.txt,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\,  Size: 348904
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\norwegian\,  Size: 341638
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\norwegian-ny\,  Size: 341691
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\polish\,  Size: 342497
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\portuguese\,  Size: 344528
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\romanian\,  Size: 343280
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\russian\,  Size: 356794
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\serbian\,  Size: 343949
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\slovak\,  Size: 342094
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\spanish\,  Size: 343222
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\swedish\,  Size: 342421
1: File: errmsg.sys,  Directory: D:\tool\Mysql\MySQL Server 8.0\share\ukrainian\,  Size: 351417
1: Action 13:33:45: CreateShortcuts. Creating shortcuts
1: Shortcut: icon.ico
1: Shortcut: Icon.MysqlCmdShell
1: Shortcut: rpxm3ds_|MySQL 8.0 Command Line Client
1: Shortcut: 7ejegqmo|MySQL 8.0 Command Line Client - Unicode
1: Action 13:33:45: WriteRegistryValues. Writing system registry values
1: Key: \SOFTWARE\MySQL AB\MySQL Server 8.0, Name: Location, Value: D:\tool\Mysql\MySQL Server 8.0\
1: Key: \SOFTWARE\MySQL AB\MySQL Server 8.0, Name: Version, Value: 8.0.26
1: Key: \SOFTWARE\MySQL AB\MySQL Server 8.0, Name: DataLocation, Value: D:\tool\Mysql\ProgramData\MySQL Server 8.0
1: Key: \SOFTWARE\MySQL AB\MySQL Server 8.0, Name: , Value: 
1: Key: \Console\MySQL 8.0 Command Line Client - Unicode, Name: FaceName, Value: Lucida Console
1: Key: \Console\MySQL 8.0 Command Line Client - Unicode, Name: FontWeight, Value: #400
1: Key: \Console\MySQL 8.0 Command Line Client - Unicode, Name: , Value: 
1: Key: \Software\MySQL AB\MySQL Server 8.0, Name: installed, Value: #1
1: Action 13:33:45: RegisterProduct. Registering product
1: {2C2F1723-07EB-4750-98AF-B3E74CD48E7E}
1: Action 13:33:45: PublishFeatures. Publishing Product Features
1: Feature: RegKeys
1: Feature: Client
1: Feature: MYSQLSERVER
1: Feature: DEVEL
1: Feature: DOCUMENTATION
1: Feature: Readme
1: Feature: ALWAYSINSTALL
1: Feature: Router
1: Feature: Server_Scripts
1: Feature: MISC
1: Feature: ProgramMenu
1: Action 13:33:45: PublishProduct. Publishing product information
1: Action 13:33:45: RollbackCleanup. Removing backup files
1: 1: MySQL Server 8.0 2: {2C2F1723-07EB-4750-98AF-B3E74CD48E7E} 3: 1 
1: The action 'Install' for product 'MySQL Server 8.0.26' completed successfully.

尝试连接我们的MySQL

我们这里使用navicat 进行连接测试

解决方法： 编辑mysql配置文件my.ini（在mysql的安装目录下，我的在D:\tool\Mysql\ProgramData\MySQL Server 8.0\my.ini），在[mysqld]这个条目下加入 skip-grant-tables 保存退出后重启mysql 1.点击“开始”->“运行”(快捷键Win+R) cmd dos 命令窗口 ==使用管理员权限==。 2.停止：输入 net stop mysql80(您的MySQL 服务名称) 3.启动：输入 net start mysql80 出现第二个问题: 这里由于安装的是8.0 原因：在my.ini中加入skip-grant-tables在mysql8.0中已失效。Mysql 8.X的方法是在命令行中使用mysqld --console --skip-grant-tables --shared-memory启动服务器然后root就可以免密登录了（需要开2个CMD窗口）。 该窗口使用mysqld --console --skip-grant-tables --shared-memory启动服务器

启动另外一个dos 命令窗口,进行登录(无密码) 设置/修改密码 使用修改后的密码进行登录 Navicat 进行连接尝试,这就成功了!!!

感谢这些作者及其作品:

安装MySql时，卡在最后一步，Attempting to start service 的解决办法 mysql Access denied for user root@localhost错误解决方法总结 mysql提示Can't connect to MySQL server on localhost (10061)解决方法 mysql8.0版本在配置文件my.ini[mysqld]加上skip-grant-tables后无法启动 mysql Access denied for user root@localhost错误 1045 Access denied for user 'root'@'localhost' (using password: YES) mysql5.7版本在配置文件my.ini[mysqld]加上skip-grant-tables后无法启动 mysql8出现The MySQL server is running with the --skip-grant-tables option so it cannot execute mysql如何修改root用户的密码 MySQL修改root登录密码的几种方法 mysql安装时卡在starting server的解决方法 添mySQL安装的时候一直卡在starting server这里解决办法 MySQl 安装失败 Starting Server启动失败，发生系统错误 1067, 进程意外终止. 解决方法 MySQL安装 starting the server失败的解决办法 mysql配置时，提示：Failed to start service MYSQL80

结尾

1.此文章本人Windows MySQL 的笔记,如有错误请各位大佬指导改正. 2.对于本人引用的链接如原作者希望特殊说明请告知,方便更改. 3.如果对上述的描述存在不了解,欢迎在帖子下评论,获取他人解答. 4.如果本文章不能解决你的问题,当然是问问万能的百度咯.