Solve the problem that the service cannot be started when installing the decompressed version of mysql 5.7.18 winx64 on Win7 x64

Solve the problem that the service cannot be started when installing the decompressed version of mysql 5.7.18 winx64 on Win7 x64

Today I downloaded mysql-5.7.18-winx64.zip from the mysql official website and unzipped it;

Then follow the steps in https://www.jb51.net/article/83646.htm to configure.

However, at the step of net start mysql, an error message is displayed: "MySQL service is starting.MySQL service cannot be started."

After several hours of searching online, I finally figured it out. The solution is as follows:

First delete the folder data under the directory ../mysql-5.7.18-winx64 (if you are not sure, you can cut it to another directory).

Then execute the initialization command mysqld --initialize .

At this time, net start mysql can be started successfully.

Attached screenshot:

The above is the solution to the problem that the service cannot be started when installing the unzipped version of MySQL 5.7.18 winx64 on Win7 x64. I hope it will be helpful to everyone. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:
  • Detailed steps for installing the decompressed version of MySQL 5.7.20 (two methods)
  • MySQL 5.7.20 common download, installation and configuration methods and simple operation skills (decompression version free installation)
  • The latest version of MySQL5.7.19 decompression version installation guide
  • Detailed graphic instructions for downloading and installing the unzipped version of MySQL 5.7.18 and starting the MySQL service
  • Tutorial on installing and changing the root password of MySQL 5.7.20 decompressed version

<<:  Summary of Ubuntu backup methods (four types)

>>:  Native js canvas to achieve a simple snake

Recommend

JavaScript Interview: How to implement array flattening method

Table of contents 1 What is array flattening? 2 A...

Nginx load balancing algorithm and failover analysis

Overview Nginx load balancing provides upstream s...

Elementui exports data to xlsx and excel tables

Recently, I learned about the Vue project and cam...

Vue realizes click flip effect

Use vue to simply implement a click flip effect f...

How to Rename a Group of Files at Once on Linux

In Linux, we usually use the mv command to rename...

ul list tag design web page multi-column layout

I suddenly thought of this method when I was writi...

Detailed explanation of three commonly used web effects in JavaScript

Table of contents 1 element offset series 1.1 Off...

Suggestions on creating business HTML emails

Through permission-based email marketing, not onl...

Node.js+postman to simulate HTTP server and client interaction

Table of contents 1. Node builds HTTP server 2. H...

Detailed steps to install CentOS7 system on VMWare virtual machine

Pre-installation work: Make sure vmware workstati...

Detailed use cases of MySql escape

MySQL escape Escape means the original semantics ...

Causes and solutions for MySQL deadlock

The database, like the operating system, is a sha...

Software Testing - MySQL (VI: Database Functions)

1.MySQL functions 1. Mathematical functions PI() ...

MySQL automatically inserts millions of simulated data operation code

I use Navicat as my database tool. Others are sim...