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

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
    关注
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 oracle集群安装出bug
  • ¥15 关于#python#的问题:自动化测试
  • ¥20 问题请教!vue项目关于Nginx配置nonce安全策略的问题
  • ¥15 教务系统账号被盗号如何追溯设备
  • ¥20 delta降尺度方法,未来数据怎么降尺度
  • ¥15 c# 使用NPOI快速将datatable数据导入excel中指定sheet,要求快速高效
  • ¥15 再不同版本的系统上,TCP传输速度不一致
  • ¥15 高德地图2.0 版本点聚合中Marker的位置无法实时更新,如何解决呢?
  • ¥15 DIFY API Endpoint 问题。
  • ¥20 sub地址DHCP问题