After mysql is installed, the service cannot be started (Summary). After mysql is installed

After mysql is installed, the service cannot be started (Summary). After mysql is installed

Mysql cannot be started after installation

1.1 Preface

Recently, it was really unlucky to get home. I have been able to greet all the problems when I installed mysql. However, this is also a valuable experience. I 'd like to sum it up, after all, I don't know if I will try again in the future. If some netizens are lucky enough to see this article and solve the problem, I am glad.

1.2 my unlucky Processes

My company's new computer has arrived. For personal reasons, I want to install mysql on my local computer to facilitate my work. I know there are two ways to install mysql: one is to automatically install the msi installation package, and the other is to unzip the zip package and install the configuration files. At the beginning, I chose msi for automatic installation without thinking about it. As a result, various errors are reported, and the installation is not successful, there is no way to download the zip package, decompress the configuration, and install mysql after a while. I just wanted to put it down and found that the mysql service could not be started, when the service is started, the database cannot be connected again. It's a real failure! I checked all kinds of materials and finally solved all the problems. The database was successfully accessed !!! I am also drunk when dealing with such a wonderful serial set, so I have to record the process of solving the main problem as much as possible. If the writing is not good, Don't scold me, my level can only be like this. In the future, I will be able to know how much water I used to have before, so that I can know my progress or a sense of accomplishment. If you don't talk nonsense, go to the topic. (PS: If the installation process encountered problems, can refer to: http://www.cnblogs.com/tanshaoxiaoji/p/mysql_install_type.html)

1.3 enter the subject,Service StartupSolution

Alter user 'root' @ 'localhost' identified'New Password'Password expire never; -- the password never expires. if you remove the NEVER, there is an expiration time.
1.4 conclusion !!!
　　In a short article, I wrote the article at, but it was still very happy to sum up the problem. Thank you for your help!