Solutions to MySql crash and service failure to start

I have been in contact with PHP for so long, but the installation environment is very unfamiliar. I encountered many problems. With the help of Baidu, I sorted out the following methods

Problem 1: MySQL service is not installed

Solution:

Find the installation directory of MySQL under cmd operation (note that cmd must be run as an administrator)
Execute the mysqld -install command with administrator privileges in the mysql bin directory

Then, still with administrator privileges, net start mysql to start the MySQL service.

1. Use the administrator's authority to net stop mysql to shut down the mysql service
2. Uninstall the MySQL service with the administrator's privileges mysqld -remove

Error:

The information is as follows:

Install/Remove of the Service Denied

Problem 2: Install/Remove of the Service Denied

Solution:

When opening the cmd.exe program, select "Open as administrator".

After opening it as an administrator, I started the service, but it still doesn't work.

Problem 3: The service cannot be started

The mysqld -console command outputs an error message. One of the error messages is that there is no mysql folder in the data directory.

Solution:

Execute mysqld –initialize to initialize the data directory

After these problems were solved, mysql started normally.

Problem 4: Wrong password

If the password is wrong, cmd will also crash.

Solution:

Tutorial on how to modify the root password in MySQL 5.7

MySQL 5.6 root password modification tutorial

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. Thank you for your support of 123WORDPRESS.COM. If you want to learn more about this, please check out the following links