mysql 安装失败，低版本自动会退 5.5.27.高版本报错 8.0.18，求大佬解决一下。安不上

电脑 win10 错误日志 1: Action 8:24:41: INSTALL. 1: 1: MySQL Server 8.0 2: {48447F31-6B57-4B13-BA5F-4D019FA995E1} 1: Action 8:24:41: FindRelatedProducts. Searching for related applications 1: Action 8:24:41: AppSearch. Searching for installed applications 1: Action 8:24:41: LaunchConditions. Evaluating launch conditions 1: Action 8:24:41: ValidateProductID. 1: Action 8:24:41: CostInitialize. Computing space requirements 1: Action 8:24:41: FileCost. Computing space requirements 1: Action 8:24:41: CostFinalize. Computing space requirements 1: Action 8:24:41: MigrateFeatureStates. Migrating feature states from related applications 1: Action 8:24:41: InstallValidate. Validating install 1: Action 8:24:41: SaveTargetDir. 1: Action 8:24:41: InstallInitialize. 1: Action 8:24:41: RemoveExistingProducts. Removing applications 1: Action 8:24:41: ProcessComponents. Updating component registration 1: Action 8:24:42: GenerateScript. Generating script operations for action: 1: Updating component registration 1: Action 8:24:42: UnpublishFeatures. Unpublishing Product Features 1: Action 8:24:42: SchedSecureObjectsRollback. 1: Action 8:24:42: RemoveRegistryValues. Removing system registry values 1: Action 8:24:42: RemoveShortcuts. Removing shortcuts 1: Action 8:24:42: RemoveFiles. Removing files 1: Action 8:24:42: RemoveFolders. Removing folders 1: Action 8:24:42: CreateFolders. Creating folders 1: Folder: Creating folders 1: Action 8:24:42: InstallFiles. Copying new files 1: File: Copying new files, Directory: , Size: 1: Action 8:24:43: CreateShortcuts. Creating shortcuts 1: Shortcut: Creating shortcuts 1: Action 8:24:43: WriteRegistryValues. Writing system registry values 1: Key: Writing system registry values, Name: , Value: 1: Action 8:24:43: InstallServices. Installing new services 1: Action 8:24:43: SchedSecureObjects. 1: Action 8:24:43: ExecSecureObjects. 1: .h, Directory: C:\Program Files\MySQL\MySQL Server 8.0\include, Size: 3100 1: File: my_command.h, Directory: C:\Program Files\MySQL\MySQL Server 8.0\include, Size: 4386

1: File: plugin_auth_common.h, Directory: C:\Program Files\MySQL\MySQL Server 8.0\include\mysql, Size: 6565 1: File: mysql_time.h, Directory: C:\Program Files\MySQL\MySQL Server 8.0\include, Size: 2996 1: File: udf_registration_types.h, Directory: C:\Program Files\MySQL\MySQL Server 8.0\include\mysql, Size: 3848 1: File: mysql_version.h, Directory: C:\Program Files\MySQL\MySQL Server 8.0\include, Size: 1120 1: File: mysqld_error.h, Directory: C:\Program Files\MySQL\MySQL Server 8.0\include, Size: 223072 1: File: mysqlx_ername.h, Directory: C:\Program Files\MySQL\MySQL Server 8.0\include, Size: 6846 1: File: mysqlx_error.h, Directory: C:\Program Files\MySQL\MySQL Server 8.0\include, Size: 3995 1: File: mysqlx_version.h, Directory: C:\Program Files\MySQL\MySQL Server 8.0\include, Size: 1861 1: File: applink.c, Directory: C:\Program Files\MySQL\MySQL Server 8.0\include\openssl, Size: 3508 1: File: http_auth_backend.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 7306752 1: File: http_auth_realm.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 7276032 1: File: http_server.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 7559680 1: File: keepalive.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 19968 1: File: libmysql.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 6692352 1: File: libmysql.lib, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 29188 1: File: libprotobuf-lite.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 427520 1: File: libprotobuf-lite.lib, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 613894 1: File: char.bin, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp, Size: 262496 1: File: dicrc, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp, Size: 693 1: File: left-id.def, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp, Size: 55910 1: File: matrix.bin, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp, Size: 3463716 1: File: pos-id.def, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp, Size: 1477 1: File: rewrite.def, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp, Size: 6241 1: File: right-id.def, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp, Size: 55910 1: File: sys.dic, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp, Size: 37779919 1: File: unk.dic, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_euc-jp, Size: 5409 1: File: char.bin, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis, Size: 262496 1: File: dicrc, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis, Size: 693 1: File: left-id.def, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis, Size: 55910 1: File: matrix.bin, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis, Size: 3463716 1: File: pos-id.def, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis, Size: 1477 1: File: rewrite.def, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis, Size: 6241 1: File: right-id.def, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis, Size: 55910 1: File: sys.dic, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis, Size: 37635899 1: File: unk.dic, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_sjis, Size: 5409 1: File: char.bin, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8, Size: 262496 1: File: dicrc, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8, Size: 693 1: File: left-id.def, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8, Size: 55910 1: File: matrix.bin, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8, Size: 3463716 1: File: pos-id.def, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8, Size: 1477 1: File: rewrite.def, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8, Size: 6241 1: File: right-id.def, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8, Size: 55910 1: File: sys.dic, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8, Size: 49199027 1: File: unk.dic, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\dic\ipadic_utf-8, Size: 5690 1: File: mecabrc, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\mecab\etc, Size: 1403 1: File: metadata_cache.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 8000000 1: File: mysql_protocol.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 90624 1: File: mysqlclient.lib, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 68780124 1: File: mysqlrouter_http.lib, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 44750 1: File: mysqlrouter_lib.lib, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 23032380 1: File: adt_null.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 25088 1: File: component_audit_api_message_emit.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 27648 1: File: component_log_filter_dragnet.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 31232 1: File: component_log_sink_json.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 16384 1: File: component_log_sink_syseventlog.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 17408 1: File: component_mysqlbackup.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 43520 1: File: component_validate_password.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 63488 1: File: connection_control.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 44032 1: File: ddl_rewriter.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 70144 1: File: group_replication.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 1688064 1: File: ha_example.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 30208 1: File: ha_mock.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 39424 1: File: keyring_file.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 101888 1: File: keyring_udf.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 23040 1: File: libpluginmecab.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 29184 1: File: locking_service.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 12800 1: File: mypluglib.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 12800 1: File: mysql_clone.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 128000 1: File: mysql_no_login.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 11776 1: File: rewrite_example.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 12800 1: File: rewriter.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 60928 1: File: semisync_master.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 75776 1: File: semisync_slave.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 29184 1: File: validate_password.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 50176 1: File: version_token.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin, Size: 54784 1: File: rest_api.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 7316992 1: File: rest_metadata_cache.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 7326208 1: File: rest_router.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 7300608 1: File: rest_routing.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 7345152 1: File: routing.dll, Directory: C:\Program Files\MySQL\MySQL Server 8.0\lib, Size: 7504384 1: File: LICENSE, Directory: C:\Program Files\MySQL\MySQL Server 8.0, Size: 408918 1: File: LICENSE.router, Directory: C:\Program Files\MySQL\MySQL Server 8.0, Size: 102977 1: File: README, Directory: C:\Program Files\MySQL\MySQL Server 8.0, Size: 687 1: File: README.router, Directory: C:\Program Files\MySQL\MySQL Server 8.0, Size: 700 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\bulgarian, Size: 303874 1: File: armscii8.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 5939 1: File: ascii.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 5925 1: File: cp1250.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 8654 1: File: cp1251.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 8783 1: File: cp1256.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 5982 1: File: cp1257.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 9315 1: File: cp850.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 5919 1: File: cp852.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 5941 1: File: cp866.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 6026 1: File: dec8.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 6942 1: File: geostd8.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 5929 1: File: greek.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 6141 1: File: hebrew.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 5930 1: File: hp8.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 5915 1: File: Index.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 19495 1: File: keybcs2.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 5942 1: File: koi8r.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 5923 1: File: koi8u.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 6945 1: File: latin1.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 10229 1: File: latin2.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 7651 1: File: latin5.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 5928 1: File: latin7.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 7851 1: File: macce.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 8460 1: File: macroman.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 8471 1: File: README, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 1749 1: File: swe7.xml, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\charsets, Size: 6943 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\czech, Size: 304266 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\danish, Size: 304266 1: File: dictionary.txt, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share, Size: 25575 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\dutch, Size: 305286 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\english, Size: 303507 1: File: errmsg-utf8.txt, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share, Size: 906390 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\estonian, Size: 303771 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\french, Size: 304914 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\german, Size: 311159 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\greek, Size: 310298 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\hungarian, Size: 304148 1: File: innodb_memcached_config.sql, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share, Size: 3999 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\italian, Size: 305277 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\japanese, Size: 310953 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\korean, Size: 306547 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\norwegian, Size: 303577 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\norwegian-ny, Size: 303630 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\polish, Size: 304436 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\portuguese, Size: 306467 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\romanian, Size: 305219 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\russian, Size: 318782 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\serbian, Size: 305888 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\slovak, Size: 304033 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\spanish, Size: 305161 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\swedish, Size: 304360 1: File: errmsg.sys, Directory: C:\Program Files\MySQL\MySQL Server 8.0\share\ukrainian, Size: 313356 1: Action 8:24:47: 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 8:24:47: WriteRegistryValues. Writing system registry values 1: Key: \SOFTWARE\MySQL AB\MySQL Server 8.0, Name: Location, Value: C:\Program Files\MySQL\MySQL Server 8.0
1: Key: \SOFTWARE\MySQL AB\MySQL Server 8.0, Name: Version, Value: 8.0.18 1: Key: \SOFTWARE\MySQL AB\MySQL Server 8.0, Name: DataLocation, Value: C:\ProgramData\MySQL\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 8:24:47: ExecSecureObjects. 1: Action 8:24:47: Rollback. Rolling back action: 1: ExecSecureObjects 1: Writing system registry values 1: Creating shortcuts 1: Copying new files 1: Creating folders 1: Updating component registration 1: 1: MySQL Server 8.0 2: {48447F31-6B57-4B13-BA5F-4D019FA995E1} 3: 3 1: The action 'Install' for product 'MySQL Server 8.0.18' failed.

MySQL

files

Directory

file

16 条回复 • 2019-11-08 15:38:08 +08:00

cz5424

2019-11-04 08:38:35 +08:00 via iPhone

Docker 一键解决烦恼

laminux29

2019-11-04 08:51:52 +08:00

1.软件安装，请遵循最佳适配平台的方法。

举个例子：

.net 这一套东西，就最好放在 Windows 上跑，即使 Linux 支持，也不要去 Linux 上瞎折腾。

回到你这个案例，MySQL 的东西，最好在 Linux 系统上安装，比如 RHEL，或 CentOS。

另外安装 MySQL 前，最好看看它对系统要求的说明，比如需要什么版本的系统，以及对 CPU、内存、磁盘的要求。

2.除非要做游戏或者驱动之类的，否则，最好不要把开发软件，比如 IDE、数据库 L 之类的软件，安装在普通用户操作系统上。比如 Windows XP、Windows 7、Windows 8 \ 10 等等。

如果要安装在 Windows 上，请使用服务器版的系统，比如 Windows Server 2008 r2 sp1。

3.如果一定要把 Mysql 安装在 Windows10 上，请确认：

A.你的 Windows10 的系统来源，是微软官方的，而不是什么乱七八糟的民间修改版，或者是买电脑时自带的家庭阉割版。

B.必须是最高版本的，Windows10 最高应该是企业版。

C.确定系统是干净的。比如，不要装流氓软件、病毒之类的。

D.如果要升级软件，一定要通过控制面板，先卸载，然后再安装新版本。而且这种方法也不一定能卸载干净。如果无法卸载干净，就重装系统。另外，系统在安装后，最好做个 GHOST 备份。这样出了问题，方便还原。

aydd2004

2019-11-04 09:06:32 +08:00 via iPhone

我记得 mysql win10 用的免安装版的然后配置下就好了安装版各种不自在
macos 倒是一路绿灯

Memento

2019-11-04 09:14:04 +08:00

看了你这么一长串的错误日志没看出来什么，给一份我免安装 5.7 的步骤试试吧，win10 下的，

1. 解压缩

2. 设置环境变量
添加变量：MYSQL_HOME=上面的解压缩路径
Path 添加：%MYSQL_HOME%\bin

3. 在 %MYSQL_HOME%\bin 目录下以管理员权限执行 mysqld --initialize-insecure --user=mysql，初始化 data 目录；

4. 在 MYSQL_HOME 根目录下新增 my.ini 文件，内容如下：

[client]
port=3306
default-character-set=utf8

[mysqld]
# 设置为自己 MYSQL 的安装目录
basedir=[%MYSQL_HOME%]
# 设置为 MYSQL 的数据目录
datadir=[%MYSQL_HOME%]\data
port=3306
character_set_server=utf8
sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER
#开启查询缓存
explicit_defaults_for_timestamp=true
skip-grant-tables
在 %MYSQL_HOME%\bin 目录下以管理员权限执行 mysqld -install 安装 MySQL 服务；

5. 如果服务安装失败，需要删除服务重新安装时，执行 sc delete mysql 即可删除服务；

6. 执行 net start mysql 启动 MySQL 服务
执行 net stop mysql 停止 MySQL 服务

sonyxperia

2019-11-04 09:18:34 +08:00

mysql 不是有安装程序的吗，配置一下点下一步就装好了啊
你是不是有遗留版本没有卸载清理干净什么的
重装系统吧

Tink

2019-11-04 09:23:59 +08:00 via iPhone

重装系统

Lockeysama

2019-11-04 09:24:57 +08:00

Docker 大法好啊~~真的好~~

ysc3839

2019-11-04 09:35:36 +08:00 via Android

@laminux29
> 1.软件安装，请遵循最佳适配平台的方法。
说说你的理由？
按照你这个说法，使用 Chrome 浏览器是不是应该使用它的“最佳适配平台” Chrome OS ？软件跨平台的意义在哪？

> 2.除非要做游戏或者驱动之类的，否则，最好不要把开发软件，比如 IDE、数据库 L 之类的软件，安装在普通用户操作系统上。
说说你的理由？
不在服务器上运行，为什么要服务器系统？这么说的话，是不是搞 macOS/iOS 开发也得先把 macOS 换成 Mac OS X Server ？ Mac OS X Server 已经停止更新了，是不是必须买台旧的支持这个系统的 Mac 电脑？

> B.必须是最高版本的，Windows10 最高应该是企业版。
说说你的理由？
这么说的话个人用户没资格使用 MySQL ？

t94P9

2019-11-04 10:32:58 +08:00 via iPhone

Mac OS X Server 没停止更新

phpfpm

2019-11-04 10:37:05 +08:00

@ysc3839 1 mysql 从来就不是跨平台的，只是其他平台可用
2 人家说的是 windows server
3 别人都有资格，你和楼主没资格。

你们太杠了

loudefa

2019-11-04 11:07:49 +08:00

docker 大法好啊，真的好

agdhole

2019-11-04 11:40:47 +08:00 via Android

Windows 下请使用这个包管理软件进行一键安装
https://chocolatey.org/

cmonkey

2019-11-04 14:19:41 +08:00

1. remove windows
2. install ArchLinux
3. yay -S docker
4. docker run --name mysql -v /opt/mysql/data:/var/lib/mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root -d mysql:5.7

zibber

2019-11-04 20:45:13 +08:00

docker

oanen

2019-11-06 08:25:10 +08:00 via iPhone

用绿色版配置环境解决

kemistep

2019-11-08 15:38:08 +08:00

https://mp.weixin.qq.com/s/mjfU-F7xIavuxN5czsLd-Q

Mysql 账号密码
方便学习 SQL，这里免费提供一组 Mysql 服务器账号，可以直接上手操作；
主机名或者 IP 地址：111.230.56.74
端口：3306
用户名：ministep
密码：datastep
备注：为便于 Mysql 服务器管理，这里对 ministep 的用户权限进行了限定；

ministep 用户权限：

default_db 数据库仅有查询权限，无其他增删改除权限；(default_db 是管理员创建表，用作教程的数据表，用户可在此数据库查询；)
temp_db 用户具有此数据库的全部权限，可以新建表，修改，查询，创建索引，可任意操作，搞坏了，不找你的；
无权限新建数据库；
鼓励在 temp_db 数据库做任何想做的事情，这里不受限制；
风险：数据库是公开的，因此上传到 temp_db 的所有内容，也是公开的，故请注意隐私保护；
Mysql 编辑器
鼓励使用 navicat 编辑器，比较好的 MySQL 数据库的图形化管理和开发工具
官方提供简体中文版供大家下载试用（ for 30days ），这里提供破解版版本

链接: https://pan.baidu.com/s/11r7xKBxiPxzHLu4_VQlvqA 密码: fpky

图形界面如下

navicat 可以方便的连接数据库，图形化管理查询；
navicat 可以很方便的导入外部 excel、csv、txt 等其他格式数据

navicat 使用操作：

Navicat for MySQL 数据库的图形化管理和开发工具