Solutions to MySql flashback and service failure to start

Contact with php for so long, but the installation environment is very rusty, encountered a lot of problems, through Baidu, sort out some of the following methods

Problem 1: the mysql service is not installed

Solution:

Locate the installation directory of mysql under the cmd operation (note that you need to run cmd as an administrator)

Execute the mysqld-install command under the mysql bin directory with administrator privileges

Then the Mysql service is still opened with administrator privileges net start mysql.

1. Shut down the mysql service with the administrator's authority net stop mysql

2. Uninstall the mysql service with the administrator's authority mysqld-remove

Error report:

The information is as follows:

Install/Remove of the Service Denied

Question 2: Install/Remove of the Service Denied

Solution:

Select "Open as administrator" when opening the cmd.exe program.

After opening it as an administrator, turn on the service, but it still won't run.

Problem 3: the service cannot be started

The error message is output with mysqld-console. One error message is that there is no mysql folder in the data directory.

Solution:

Execute mysqld-initialize to initialize the data directory

After dealing with these problems, mysql started normally.

Question 4: incorrect password

Incorrect password can also cause cmd flashback

Solution:

Mysql5.7 modify root password tutorial

Mysql5.6 modify root password tutorial

Summary

The above is the whole content of this article. I hope the content of this article has a certain reference and learning value for everyone's study or work. Thank you for your support. If you want to know more about it, please see the relevant links below.