Shulou(Shulou.com)05/31 Report--

Editor to share with you how to solve the problem that the mysql service in window can not be started, I believe most people don't know much about it, so share this article for your reference. I hope you can learn a lot after reading this article. Let's learn about it together.

The solution that the mysql window service cannot start: 1, find the mysql installation directory and move its configuration file my.ini to the bin directory; 2, enter the bin directory under the command line mode with administrator privileges; 3, execute "mysqld-- initialize..." Just give the order.

This article operating environment: Windows7 system, Mysql5.7 version, Dell G3 computer.

What if the mysql window service fails to start?

Resolve the issue that windows is unable to start the MySQL service:

1. The dialog box shown in the following figure appears when you start the MySQL service

two。 Locate the mysql installation directory and move its configuration file my.ini to the bin directory.

3. Enter the bin directory in command line mode with administrator privileges.

4. Next, execute the command on the command line: mysqld-- initialize-- user=mysql-- console. Note that this step will get a temporary password that needs to be recorded and will be used later.

5. Then type: mysqld-- install in command line mode to install the service. After the installation is complete, find the "service" in the task manager and start the MySQL service in it.

6. Finally, enter mysql-uroot-p on the command line and log in to the database successfully using the previous temporary password.

7. If you want to change the password, type mysqladmin-u root-p password root on the command line. The first root is the user name and the second root is the password.

The above is all the contents of this article entitled "how to solve the problem that the mysql service cannot be started in window". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, 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.