qq_19685355 2017-09-19 18:21 采纳率: 0%
浏览 4117
已结题

MySql安装一直卡在starting serverq 求解答 贴上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: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
Waiting for the server stops: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
2017-09-19T18:14:08.853281Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-19T18:14:08.853281Z 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-19T18:14:14.079270Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-09-19T18:14:15.654948Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
mysqld: File '.\绁栧帤涔?slow.log' not found (Errcode: 2 - No such file or directory)
2017-09-19T18:14:15.951298Z 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-19T18:14:15.966926Z 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: 58c698a0-9d66-11e7-ab89-201a06371a86.
2017-09-19T18:14:16.138545Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-09-19T18:14:16.388094Z 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

  • 写回答

5条回答 默认 最新

  • cloudyzhao 2017-09-20 00:20
    关注

    1、卸载MySQL应用程序,要把MySQL的服务业卸载掉,命令窗口使用: sc delete MySQL
    2、清理注册表(找出来删掉)
    复制代码 代码如下:

    HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications/MySQL
    HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Applications/MySQL
    HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Applications/MySQL
    3、清理残余文件项,特指MySQL的数据文件
    1)安装目录有残余项,手动删除
    2)显示隐藏文件及文件夹(文件夹选项->查看->显示隐藏文件的文件、文件夹和驱动器),这是避免你找不到目录,然后就去安装目录找吧,windows 7 下MySQL的数据文件在一个隐藏的ProgramData文件夹里,或者用懒人的办法,在搜索栏输入“mysql”,列出全部有关mysql的文件和文件夹。
    4、重装MySQL,按照正常流程,成功了。

    评论

报告相同问题?

悬赏问题

  • ¥15 (希望可以解决问题)ma和mb文件无法正常打开,打开后是空白,但是有正常内存占用,但可以在打开Maya应用程序后打开场景ma和mb格式。
  • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
  • ¥20 腾讯企业邮箱邮件可以恢复么
  • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?
  • ¥15 错误 LNK2001 无法解析的外部符号
  • ¥50 安装pyaudiokits失败
  • ¥15 计组这些题应该咋做呀
  • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?
  • ¥15 让node服务器有自动加载文件的功能
  • ¥15 jmeter脚本回放有的是对的有的是错的