V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
MySQL 5.5 Community Server
MySQL 5.6 Community Server
Percona Configuration Wizard
XtraBackup 搭建主从复制
Great Sites on MySQL
Percona
MySQL Performance Blog
Severalnines
推荐管理工具
Sequel Pro
phpMyAdmin
推荐书目
MySQL Cookbook
MySQL 相关项目
MariaDB
Drizzle
参考文档
http://mysql-python.sourceforge.net/MySQLdb.html
oanen
V2EX  ›  MySQL

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

  •  
  •   oanen · 2019-11-04 08:27:46 +08:00 · 6076 次点击
    这是一个创建于 1831 天前的主题,其中的信息可能已经有所发展或是发生改变。

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

    16 条回复    2019-11-08 15:38:08 +08:00
    cz5424
        1
    cz5424  
       2019-11-04 08:38:35 +08:00 via iPhone
    Docker 一键解决烦恼
    laminux29
        2
    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
        3
    aydd2004  
       2019-11-04 09:06:32 +08:00 via iPhone
    我记得 mysql win10 用的免安装版的然后配置下就好了 安装版各种不自在
    macos 倒是一路绿灯
    Memento
        4
    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
        5
    sonyxperia  
       2019-11-04 09:18:34 +08:00
    mysql 不是有安装程序的吗,配置一下点下一步就装好了啊
    你是不是有遗留版本没有卸载清理干净什么的
    重装系统吧
    Tink
        6
    Tink  
       2019-11-04 09:23:59 +08:00 via iPhone
    重装系统
    Lockeysama
        7
    Lockeysama  
       2019-11-04 09:24:57 +08:00
    Docker 大法好啊~~真的好~~
    ysc3839
        8
    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
        9
    t94P9  
       2019-11-04 10:32:58 +08:00 via iPhone
    Mac OS X Server 没停止更新
    phpfpm
        10
    phpfpm  
       2019-11-04 10:37:05 +08:00
    @ysc3839 1 mysql 从来就不是跨平台的,只是其他平台可用
    2 人家说的是 windows server
    3 别人都有资格,你和楼主没资格。

    你们太杠了
    loudefa
        11
    loudefa  
       2019-11-04 11:07:49 +08:00
    docker 大法好啊,真的好
    agdhole
        12
    agdhole  
       2019-11-04 11:40:47 +08:00 via Android
    Windows 下请使用这个包管理软件进行一键安装
    https://chocolatey.org/
    cmonkey
        13
    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
        14
    zibber  
       2019-11-04 20:45:13 +08:00
    docker
    oanen
        15
    oanen  
    OP
       2019-11-06 08:25:10 +08:00 via iPhone
    用绿色版配置环境解决
    kemistep
        16
    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 数据库的图形化管理和开发工具
    关于   ·   帮助文档   ·   博客   ·   API   ·   FAQ   ·   实用小工具   ·   3255 人在线   最高记录 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 23ms · UTC 00:38 · PVG 08:38 · LAX 16:38 · JFK 19:38
    Developed with CodeLauncher
    ♥ Do have faith in what you're doing.