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

This article mainly introduces mysql can not successfully start the service solution, the text is very detailed, has a certain reference value, interested friends must read!

mysql failed to start the service solution: first localhost mapping address comment out; then enter mysql bin directory initialization mysql; finally, execute the net start mysql command again to start the service.

MySQL cannot successfully start the service solution:

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

Solution:

1. Comment out the address mapped by localhost

2. If there is no configuration file in the mysql installation path (C:\Program Files\MySQL\MySQL Server 8.0), manually create one yourself with the file name: my.ini and add the following contents:

Note: the datadir attribute after the data folder, must not manually create their own, I try to manually create a problem, if you create it can be deleted, and then perform the following operations.

3. By default, there is no data directory in mysql version 5.7 or above, that is, there is no initialization service. You need to initialize mysql before you can start the service, otherwise you will report that "the service did not report any errors" and the start will fail.

Solution:

Enter the bin directory of mysql;

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

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

The above is all the content of mysql failed to start the service solution, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to 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.