The MySQL service on the local computer is stopped after it is started. Some services will be automated when they are not used by other services or programs, and other mysql services

The MySQL service on the local computer is stopped after it is started. Some services will be automated when they are not used by other services or programs, and other mysql services

Re-install the MySQL database. Due to the sloppy installation, all the way to next (in fact, strict configuration is required in some places and I forgot to pay attention to it), it is a lot of trouble now.

Error message:

The MySQL service on the local computer is stopped after it is started. Some services are automatically used when they are not used by other services or programs.

I re-download the Community edition mysql-installer-community-5.6.31.0 on the MySQL official website, this version is free of charge.

Run the windows Service as a system user. Note: In Windows, the MySQL service name is mysql57. No longer mysql

Solution:

1. First, you need to delete the original service

(Mysql is your service name, which can be customized by yourself.
This command needs to run in the bin directory under the mysql installation directory)

Mysqld -- remove mysql

2. In the root directory of mysql, clear the data directory.

(If there is no data directory, create an empty directory named data !)

3. Run the following command:

Mysqld -- install mysql -- defaults-file = C: \ Program Files \ MySQL \ my. ini

C: \ Program Files \ MySQL, and change the path to your own! This is the mysql service registration!

4. Run the startup service command as an administrator:

Net start mysql57

Additional: View logs and view password settings: