2 qq 19685355 qq_19685355 于 2017.09.20 02:21 提问

MySql安装一直卡在starting serverq 求解答 贴上log 100C

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个回答

zy841958835
zy841958835   Ds   Rxr 2017.09.20 08: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,按照正常流程,成功了。

baidu_26611019
baidu_26611019   2017.09.20 08:32

从报错来看问题在于:mysqld: File '.\绁栧帤涔?slow.log' not found 这个文件不存在,导致下面的error Could not use 绁栧帤涔?slow.log
日志建议restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.意思是把
SET GLOBAL SLOW_QUERY_LOG=ON 这个属性设置为ON 或者重新启动MySQL。归纳起来原因应该是数据库启动没有完全成功,你可以进入系统
服务将MySQL停止后再启动,或者进入MySQL的bin目录,执行停止、启动脚本重启MySQL。

baidu_26611019
baidu_26611019 你的MySQL是通过什么方式安装的?直接解压的,还是安装包安装的呀?MySql的安装强烈建议用安装包,并且选用默认路径。针对你现在的情况最好按照楼下的方法八MySQL清理干净再装新的。这些莫名其妙的问题还真不好搞.
2 个月之前 回复
qq_19685355
qq_19685355 这个文件夹是什么呀。
2 个月之前 回复
qq_26433213
qq_26433213   2017.09.20 09:15
1
 在控制面板里把Mysql正常卸载
2
C:\Documents and Settings\All Users\Application Data\MySQL   这里还有MySQL的文件,必须要删除   注意:Application Data这个文件夹是隐藏的,需要打开个文件夹选择菜单栏 工具→文件夹选项→查看→隐藏文件和文件夹 一项选    上 显示所有文件和文件夹 确定 
3
删除MySQL文件夹下的my.ini文件,如果备份好,可以直接将文件夹全部删除
4
 开始->运行-> regedit 看看注册表里这几个地方删除没有   HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL 目录删除   HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL 目录删除   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL 目录删除(我卸载的时候没有找到,略过后仍达到完全卸载的目的。) 
qq_37110005
qq_37110005   2017.09.20 09:27

管那么多干嘛,我都是直接默认选中一直点下一步就完成了

qq_19685355
qq_19685355   2017.09.20 10:36

1和3的方法我都时光哟很多次了 。不行电脑里面的软件也卸载了。该删的都删了。就是不行呀。

Csdn user default icon
上传中...
上传图片
插入图片