win7 64位 安装MySQL 5.6 到Configuration卡死在Attempting to start service 解决

本文介绍了当遇到MySQL服务无法启动的情况时的解决步骤:通过调整登录账户为本地系统账户来解决问题。通常此问题可能由系统中ASP.NET用户名被删除或禁用引起。
右键“我的电脑” → 点“管理” → “服务和应用程序” → “服务” → 在里面找到 “mysqlXX” → 右键 "属性" → 点击“登录”

选择 本地系统账户后 点击确定 ,然后再 右键 启动 就可以了。


这个问题主要是 mysql服务无法正常启动导致卡在了最后一步。至于为什么mysql服务会无法登录到系统,可能是由于系统中的 ASP.NET 用户名被删除或

者被禁用造成的。

Attempting to grant Network Service require filesystem permissions. Granted permissions. Adding new service New service added Ended configuration step: Adjusting Windows service Beginning configuration step: Initializing database (may take a long time) Deleting the data directory from a previous (failed) configuration... Attempting to run MySQL Server with --initialize-insecure option... Starting process for MySQL Server 5.7.27... Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\data\my.ini" --console --initialize-insecure=on --lower-case-table-names=1... 2025-05-14T04:07:04.765197Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2025-05-14T04:07:04.765273Z 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. 2025-05-14T04:07:04.944470Z 0 [Warning] InnoDB: New log files created, LSN=45790 2025-05-14T04:07:04.978923Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. mysqld: File '.\鐧戒匠绂?slow.log' not found (Errcode: 2 - No such file or directory) 2025-05-14T04:07:05.038190Z 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. 2025-05-14T04:07:05.050808Z 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: e558e150-3078-11f0-bacc-88a4c2a2d33a. 2025-05-14T04:07:05.052731Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2025-05-14T04:07:05.069636Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. Process for mysqld, with ID 1100, was run successfully and exited with code 0. Successfully started process for MySQL Server 5.7.27. MySQL Server 5.7.27 intialized the database successfully. Ended configuration step: Initializing database (may take a long time) Beginning configuration step: Starting the server Attempting to start service MySQL57...
05-15
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值