Sharing solutions to the problem of MySQL crashing frequently (picture)

I just learned about databases and installed MySQL. Just when I was happy, I found that my MySQL crashed. I have been searching online for a solution for a long time. Finally solved this problem and feel relieved.

The problem starts here:

Then I opened MySQL and wondered if it could be used, but it crashed.

Then I went to the server and checked whether it was turned on. I tried to turn it on and found that it didn't work either.

There are results on the Internet saying that I need to delete my.ini under Windows.

But, I hesitated for a long time. I felt that the problem was not here, and I didn’t want to delete it.

It is said on the Internet to set up hosts. I have already set up "127.0.0.1 localhost" before.

Some netizens said that they tried to operate cmd bala bala as an administrator for a long time. It doesn't work for me.

Later I found a method that felt closer to the answer I wanted. I tried it and it worked! ! ! !

The steps to solve the MySQL crash problem are as follows:

1. Use cmd to enter the MySQL installation directory bin;

2. Enter the command:
mysqladmin -uroot password root, and then press Enter.

At this time, the password of MySQL user root is set to root.

3. Open MySQL 5.0 Command Line Client, enter the password root, no crash occurs, and the problem is solved.

or

The above is the detailed content of Sharing solutions to the problem of MySQL crashing frequently (picture). For more information, please follow other related articles on the PHP Chinese website!