qq_39194130 2017-09-19 08:46 采纳率: 100%
浏览 4744
已采纳

win10 mysql 5.7.17 安装卡在starting server

win 10 mysql5.7.17 安装卡在starting server,网上找了很多方法,比如用本地系统账户手动启动,或者删除注册表重装,还有更改my.ini,都没有用。
按照网上的说法也没有找到.err文件,结果发现这个文件直接显示在安装界面上了(尴尬)

下面是log

Beginning configuration step: Stopping Server [if necessary]
Ended configuration step: Stopping Server [if necessary]

Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file

Beginning configuration step: Updating firewall
Adding firewall rule for MySQL57 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewall

Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]

Beginning configuration step: Initializing Database [if necessary]
Deleting Data folder shipped
Attempting to run MySQL Server with --Initialize-insecure
Running process: F:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="F:\Program Files\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
Waiting for the server stops: F:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="F:\Program Files\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
2017-09-18T13:50:15.638257Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-18T13:50:15.638257Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-09-18T13:50:25.360635Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-09-18T13:50:25.907212Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
mysqld: File '.\褰煎コ銇█銇勩伨銇?slow.log' not found (Errcode: 2 - No such file or directory)
2017-09-18T13:50:26.125979Z 0 [ERROR] Could not use 褰煎コ銇█銇勩伨銇?slow.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
2017-09-18T13:50:26.141566Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 530d3483-9c78-11e7-9ec9-54e1ad2321ad.
2017-09-18T13:50:26.188451Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-09-18T13:50:26.204073Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
Finished initialize database
Ended configuration step: Initializing Database [if necessary]

Beginning configuration step: Starting Server
Starting MySQL as a service

路径有问题,是乱码,但是我的安装路径是全英文的,mysqld能在文件夹下找到,在dos下也启动不了。
使用它的默认路径也还是这个问题。

  • 写回答

1条回答 默认 最新

  • MikeDDT009 2017-09-19 09:33
    关注
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥30 STM32 INMP441无法读取数据
  • ¥100 求汇川机器人IRCB300控制器和示教器同版本升级固件文件升级包
  • ¥15 用visualstudio2022创建vue项目后无法启动
  • ¥15 x趋于0时tanx-sinx极限可以拆开算吗
  • ¥500 把面具戴到人脸上,请大家贡献智慧
  • ¥15 任意一个散点图自己下载其js脚本文件并做成独立的案例页面,不要作在线的,要离线状态。
  • ¥15 各位 帮我看看如何写代码,打出来的图形要和如下图呈现的一样,急
  • ¥30 c#打开word开启修订并实时显示批注
  • ¥15 如何解决ldsc的这条报错/index error
  • ¥15 VS2022+WDK驱动开发环境