What should I do if mysql cannot successfully start the service

The solution to the failure of mysql to start the service successfully: first comment out the address mapped by localhost; then enter the bin directory of mysql to initialize mysql; finally execute the net start mysql command again to start the service.

Note: The data folder after the datadir attribute must not be manually created by yourself. If I try to create it manually, there will be problems. If you create it yourself, you can delete it. Then perform the following operations.

3. In versions above mysql5.7, there is no data directory by default, that is, there is no initialization service. You need to initialize mysql before you can start the service, otherwise it will report “the service did not report any errors” and the startup will fail.

Solution:

• Enter the bin directory of mysql;

• Execute mysqld –initialize-insecure, the first time you execute it, it will take longer, and there will be no output information after the execution. Check the bin directory at the same level and there will be a data folder with a bunch of files inside .

4. Execute the net start mysql command again to start the service, and found that the startup is successful!

More related free learning recommendations: mysql tutorial (video)

The above is the detailed content of how to do if mysql cannot successfully start the service, please pay attention to more 1024programmer.com Other related articles!