Solution to 1067 when Mysql starts in Windows

I just started working a few days ago and installed Mysql and it was just able to open. Today I went to the company and found that I could not start the service and reported error 1067. I looked up some solutions on the Internet and found many versions. The following is my solution:

1. Open Run-Event Viewer--Windows Log--Application--Find Error Sign, as shown below

Since you are using the installed version, the Datadir under My.ini has not been modified, so an error is reported and the data file cannot be found when starting. Therefore, you need to change the Datadir in the my.ini file to the data file under your installation path.

Then save and restart.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:

Causes and solutions for invalid service name when starting MySQL service under Windows 7
Windows cannot start MySQL service and reports error 1067 solution
Solution to MySQL 5.7 not starting under Windows
Using batch processing to start and shut down mysql under Windows
How to install and start MySQL under Windows
Simple solution to the Chinese garbled characters and service startup problems of MySQL in Windows
Detailed graphic tutorial on installation, startup and basic configuration of MySQL under Windows version
Windows10 mysql 8.0.12 non-installation version configuration startup method
Solve the problem of PhPStudy MySQL startup failure under Windows system
Universal solution for MySQL failure to start under Windows system

<<: File sharing between Ubuntu and Windows under VMware

>>: Setting up shared folders in Ubuntu virtual machine of VMWare14.0.0

Solve the problem of using swiper plug-in in vue

Solution to 1067 when Mysql starts in Windows

Solve the problem of using swiper plug-in in vue

vitrualBox+ubuntu16.04 install python3.6 latest tutorial and detailed steps

Pay attention to the order of TRouBLe when writing shorthand properties in CSS (to avoid pitfalls)

Automatic failover of slave nodes in replication architecture in MySQL 8.0.23

Detailed explanation of the use of MySQL comparison operator regular expression matching REGEXP

Windows 10 1903 error 0xc0000135 solution [recommended]

Detailed explanation of creating and calling MySQL stored procedures

Implementation of whack-a-mole game in JavaScript

Vue element implements table adding, deleting and modifying data

Detailed explanation of how to upgrade software package versions under Linux

Recommend

Summary of the operation records of changing MyISAM storage engine to Innodb in MySQL

In-depth study of how to use positioning in CSS (summary)

4 principles for clean and beautiful web design

Teach you how to implement the observer mode in Javascript

HTML basics HTML structure

Detailed explanation of keywords and reserved words in MySQL 5.7

MySQL 5.7.17 compressed package installation-free configuration process diagram

Linux uses the scp command to copy files to the local computer and copy local files to the remote server

Ten popular rules for interface design

WeChat applet implements calculator function

Implementation of multi-site configuration of Nginx on Mac M1

Implementation of MySQL index-based stress testing

The core process of nodejs processing tcp connection

Solution to the problem that docker nginx cannot be accessed after running

mysql having usage analysis