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

Summary of the differences between MySQL and Oracle (comparison of functional performance, selection, SQL when using them, etc.)

1. Concurrency Concurrency is the most important ...

Solution to 1067 when Mysql starts in Windows

HTML tag default style arrangement

A brief discussion on the pitfalls and solutions of the new features of MySQL 8.0 (summary)

JavaScript's unreliable undefined

Docker Modify Docker storage location Modify container image size limit operation

Vue's Render function

Detailed explanation of how two Node.js processes communicate

IE6 space bug fix method

Detailed explanation of Axios asynchronous communication in Vue

jQuery treeview tree structure application

Vue code highlighting plug-in comprehensive comparison and evaluation

Recommend

How to export mysql table structure to excel

Copy and paste is the enemy of packaging

Implementing search box function with search icon based on html css

Vue realizes click flip effect

Vue Element front-end application development conventional Element interface components

js to realize login and registration functions

How to solve the problem that MySQL cannot start because it cannot create PID

Implementation of building Kubernetes cluster with VirtualBox+Ubuntu16

Hide div in HTML Hide table TABLE or DIV content css style

Summary of the differences between MySQL and Oracle (comparison of functional performance, selection, SQL when using them, etc.)

Example of using Dockerfile to build an nginx image

Detailed description of mysql replace into usage

Essential bonus items for optimizing and packaging the front end of Vue projects

JavaScript canvas realizes dynamic point and line effect

Linux uses stty to display and modify terminal line settings