Saving my.ini configuration file...
Saved my. Ini configuration file.
Ended the configuration step: Writing the configuration file
Beginning the configuration step: Updating the Windows Firewall rules
Adding a Windows Firewall rule for MYSQL80 on port 3306.
Attempting to add a Windows Firewall rule with the command: netsh. Exe advfirewall Firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
Sure,
Successfully added to the Windows Firewall rule.
Adding a Windows Firewall rule for MYSQL80 on port 33060.
Attempting to add a Windows Firewall rule with the command: netsh. Exe advfirewall Firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow
Sure,
Successfully added to the Windows Firewall rule.
Ended the configuration step: Updating the Windows Firewall rules
Beginning the configuration step: Adjusting Windows service
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
The New service added
Ended the configuration step: Adjusting Windows service
Beginning the configuration step: the 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 the process for MySQL Server 8.0.17...
Starting the process with the command: C: \ Program Files \ MySQL \ MySQL Server 8.0 \ bin \ mysqld exe - defaults - file="C: \ ProgramData/MySQL/MySQL Server 8.0 \ my ini" - the console - the initialize - insecure=on - the lower - case - table - names=1...
'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO SQL modes should be 2 with strict mode. They will be merged with strict mode in a future release.
C: \ Program Files \ MySQL \ MySQL Server 8.0 \ bin \ mysqld exe (mysqld 8.0.17) initializing of Server in progress as the process of 14260
MYSQL_BIN_LOG: : set_crash_safe_index_file_name failed to set the file name.
The newly created data directory C: \ ProgramData/MySQL/MySQL Server 8.0 \ data \ by -- The initialize is very often. You can remove it.
Aborting
C: \ Program Files \ MySQL \ MySQL Server 8.0 \ bin \ mysqld exe: Shutdown complete (mysqld 8.0.17) MySQL Community Server - the GPL.
The Process for mysqld, with ID 14260, was run successfully and exited with code 1.
Failed to start the process for MySQL Server 8.0.17.
Database initialization failed.
Ended the configuration step: the Initializing database (may take a long time)
CodePudding user response:
https://blog.csdn.net/sinat_28984567/article/details/102535923? SPM=1001.2014.3001.5502