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,按照正常流程,成功了。

    评论

报告相同问题?

悬赏问题

  • ¥60 版本过低apk如何修改可以兼容新的安卓系统
  • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
  • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
  • ¥50 有数据,怎么用matlab求全要素生产率
  • ¥15 TI的insta-spin例程
  • ¥15 完成下列问题完成下列问题
  • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
  • ¥15 YoloV5 第三方库的版本对照问题
  • ¥15 请完成下列相关问题!
  • ¥15 drone 推送镜像时候 purge: true 推送完毕后没有删除对应的镜像,手动拷贝到服务器执行结果正确在样才能让指令自动执行成功删除对应镜像,如何解决?