Shulou(Shulou.com)06/01 Report--

How can mysql be configured incorrectly to start the service? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The solution to the failure to start the service due to mysql configuration error: 1. Comment out the address mapped by localhost; 2. Enter the bin directory of mysql and execute the [mysqld-- initialize-insecure] command.

Solution to the failure to start the service due to mysql configuration error:

1. Check the host file (C:\ Windows\ System32\ drivers\ etc\ hosts) to see if the local domain name has been modified. If the corresponding address of localhost is modified, the connection to mysql server may fail.

Solution: comment out the address of the localhost map

2. If there is no configuration file in the installation path of mysql (C:\ Program Files\ MySQL\ MySQL Server 8.0), create one manually. The file name is: my.ini, and the contents are as follows:

Note: the data folder after the datadir attribute must not be created manually. It will be a problem if I try to create it manually. If you create it yourself, you can delete it, and then perform the following operations.

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

Solution:

A. Enter the bin directory of mysql

B. Execute mysqld-- initialize-insecure. If you execute it for the first time, it will take a long time. After the execution, there is no output information. If you check the bin sibling directory, there will be an extra data folder with a pile of files in it.

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

Thank you for reading! After reading the above, do you have a general idea of how mysql is configured incorrectly and cannot start the service? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.