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

What if MySQL fails to start? This problem may be often seen in our daily work. Through this question, I hope you can gain more. Let's take a look at the solution with the editor today.

The method 1:data folder is created by yourself. Delete the data folder and enter this command under the folder where you go to MySQL in the DOS interface: mysqld-- initialize, and reinitialize a data file.

Method 2: configure my.ini. The following one seems to talk about configuring my.ini.

Https://blog.csdn.net/liyangyang0528/article/details/54233632#commentBox

Method 3: see if your IP is occupied and port 3306 is occupied.

Method 4: enter the mysqld-- console command in the bin directory of the MySQL folder in the DOS interface to query the error log.

The mistakes I have encountered:

Method 5: enter the mysqld-- console command in the xshell interface to query the error log, and then find that the error log shows that MySQL has been started, but cannot open MySQL. Later, I deleted the mysql.sock file in the / var/lib/mysql/ directory and restarted / etc/init.d/mysqld restart.

Then you can enter:

This is the end of the solution to the problem that MySQL cannot be started. Solving the problem is not just the method analyzed in the article and everyone, but the accuracy of the analysis method in this article is beyond doubt. If you like this article, you might as well share it for more people to see.

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.