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

Share a Markdown editor based on Ace

I think editors are divided into two categories, ...

Building an image server with FastDFS under Linux

Table of contents Server Planning 1. Install syst...

Solve the problem of docker's tls (ssl) certificate expiration

Problem phenomenon: [root@localhost ~]# docker im...

Detailed explanation of the basic implementation principle of MySQL DISTINCT

Preface DISTINCT is actually very similar to the ...

Detailed explanation of the use of custom parameters in MySQL

MySQL variables include system variables and syst...

Detailed explanation of the JVM series memory model

Table of contents 1. Memory model and runtime dat...

Use html-webpack-plugin' to generate HTML page plugin in memory

When we package the webpackjs file, we introduce ...

MYSQL database basics - Join operation principle

Join uses the Nested-Loop Join algorithm. There a...

Pure CSS3 realizes the effect of div entering and exiting in order

This article mainly introduces the effect of div ...

Detailed explanation of Linx awk introductory tutorial

Awk is an application for processing text files, ...

Three commonly used MySQL data types

Defining the type of data fields in MySQL is very...

Mariadb remote login configuration and problem solving

Preface: The installation process will not be des...

CentOS 7.x docker uses overlay2 storage method

Edit /etc/docker/daemon.json and add the followin...

WeChat applet records user movement trajectory

Table of contents Add Configuration json configur...