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

2019-11-04 08:27:46 +08:00
 oanen

电脑 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.

6090 次点击
所在节点    MySQL
16 条回复
cz5424
2019-11-04 08:38:35 +08:00
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
我记得 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
重装系统
Lockeysama
2019-11-04 09:24:57 +08:00
Docker 大法好啊~~真的好~~
ysc3839
2019-11-04 09:35:36 +08:00
@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
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
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
用绿色版配置环境解决
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 数据库的图形化管理和开发工具

这是一个专为移动设备优化的页面(即为了让你能够在 Google 搜索结果里秒开这个页面),如果你希望参与 V2EX 社区的讨论,你可以继续到 V2EX 上打开本讨论主题的完整版本。

https://www.v2ex.com/t/615930

V2EX 是创意工作者们的社区,是一个分享自己正在做的有趣事物、交流想法,可以遇见新朋友甚至新机会的地方。

V2EX is a community of developers, designers and creative people.

© 2021 V2EX