Mysql8.0.22 failed: start the mysql service cannot be started not report any error solution-CodePudding

Performed in CMD an administrator to run the.net start mysql display cannot be started, but did not report any errors,

Key check my. Ini files and data to create ways to try the solution:

1. My. Ini ANSI encoding setting, the default utf-8 ()
To build my first. TXT, the file save too change code set to ANSI

2.. My. Ini file path does not replace

 
 [mysql]
# set the mysql client default character set 
Default - character - set=utf8 

[mysqld] 

# set port 3306 
Port=3306 

# set the mysql installation directory, here remember to own path 
Basedir=D: \ \ Program Files \ mysql - 8.0.22 - winx64 

# set the mysql database data storage directory,] here to own 
Datadir=D: \ \ Program Files \ mysql - 8.0.22 - winx64 \ data 

# to allow maximum number of connections 
Max_connections=200 

# server character set the default use 8 bits for coding the latin1 character set 
Character - set - server=utf8 

# to create a new table will use the default storage engine 
Default - storage - engine=INNODB

3. my. Ini files must be put in the bin folder!!!!!! Rather than mysql version - * * winx64 folder
I'm stuck in this step tried all methods to find the ini file is in a wrong position

4. Mysql above mysql5.7 version by default there is no a data directory, which is not initialized, need first initialized mysql to start the service, or you will quote "service has not reported any error", start-up failure,
A. delete create data folder
B. as an administrator to enter CMD, input: CD mysql bin directory;

C. perform mysqld -- the initialize - insecure, carried out for the first time, time will be longer, after the execution without output information, see the bin directory at the same level will be more a data folder, inside a pile of papers,

D. again net start mysql command to start the service, found that start-up success!