只有在任务处于完成状态(RanToCompletion、Faulted 或 Canceled)时才能释放它

您所在的位置：网站首页 › 安装mysql55步骤 › 只有在任务处于完成状态(RanToCompletion、Faulted 或 Canceled)时才能释放它

只有在任务处于完成状态(RanToCompletion、Faulted 或 Canceled)时才能释放它

2023-12-16 21:31| 来源: 网络整理| 查看: 265

只有在任务处于完成状态(RanToCompletion、Faulted 或 Canceled)时才能释放它原创

fengyuzaitu 2023-04-24 14:49:37 博主文章分类：数据库 ©著作权

文章标签 MySQL Windows Server 文章分类 MySQL 数据库

©著作权归作者所有：来自51CTO博客作者fengyuzaitu的原创作品，请联系作者获取转载授权，否则将追究法律责任 MySQL版本

mysql-installer-community-5.7.41.0.msi

服务器版本

只有在任务处于完成状态(RanToCompletion、Faulted 或 Canceled)时才能释放它_MySQL

启动服务失败

安装配置正常，最后一步启动MySQL服务失败

提示报错信息：

Attempting to start service MySQL57..... Failed to start service MySQL57. 只有在任务处于完成状态(RanToCompletion、Faulted 或 Canceled)时才能释放它。 Ended configuration step: Starting the server

如下是详细的安装打印信息

ginning configuration step: Writing configuration file Saving my.ini configuration file... Saved my.ini configuration file. Ended configuration step: Writing configuration file Beginning configuration step: Updating Windows Firewall rules Adding a Windows Firewall rule for MySQL57 on port 3306. Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow 确定。 Successfully added the Windows Firewall rule. Ended configuration step: Updating Windows Firewall rules Beginning configuration step: Adjusting Windows service Attempting to grant the required filesystem permissions to the 'NT AUTHORITY\NetworkService' account. Granted permissions to the data directory. 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.41... Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --console --initialize-insecure=on --lower-case-table-names=1... TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). InnoDB: New log files created, LSN=45790 InnoDB: Creating foreign key constraint system tables. 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: d93c25fe-e24f-11ed-8412-000c29556b74. Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. CA certificate ca.pem is self signed. root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. Process for mysqld, with ID 4272, was run successfully and exited with code 0. Successfully started process for MySQL Server 5.7.41. MySQL Server 5.7.41 intialized the database successfully. Ended configuration step: Initializing database (may take a long time) Beginning configuration step: Updating permissions for the data folder and related server files Attempting to update the permissions for the data folder and related server files... Inherited permissions have been converted to explicit permissions. Full control permissions granted to: NETWORK SERVICE. Full control permissions granted to: Administrators. Full control permissions granted to: CREATOR OWNER. Full control permissions granted to: SYSTEM. Access to the data directory is removed for the users group. Permissions for the data folder and related server files are updated correctly. Ended configuration step: Updating permissions for the data folder and related server files Beginning configuration step: Starting the server Attempting to start service MySQL57..... Failed to start service MySQL57. 只有在任务处于完成状态(RanToCompletion、Faulted 或 Canceled)时才能释放它。 Ended configuration step: Starting the server ............

解决方案一

打开服务，找到服务名称MySQL57,点击属性

只有在任务处于完成状态(RanToCompletion、Faulted 或 Canceled)时才能释放它_Server_02