Solution to 1067 when Mysql starts in Windows

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

Recommend

Detailed explanation of Nginx timeout configuration

I recently used nginx in a project, and used Java...

How to use the jquery editor plugin tinyMCE

Modify the simplified file size and download the ...

Solution to the impact of empty paths on page performance

A few days ago, I saw a post shared by Yu Bo on G...

Detailed explanation of the usage of position attribute in HTML (four types)

The four property values ​​of position are: 1.rel...

In-depth explanation of MySQL stored procedures (in, out, inout)

1. Introduction It has been supported since versi...

H tags should be used reasonably in web page production

HTML tags have special tags to handle the title of...

uniapp project optimization methods and suggestions

Table of contents 1. Encapsulate complex page dat...

Detailed explanation of galera-cluster deployment in cluster mode of MySQL

Table of contents 1: Introduction to galera-clust...

Common usage of regular expressions in Mysql

Common usage of Regexp in Mysql Fuzzy matching, c...

Detailed explanation of JavaScript stack and copy

Table of contents 1. Definition of stack 2. JS st...

MySQL/MariaDB Root Password Reset Tutorial

Preface Forgotten passwords are a problem we ofte...

Implementation code of using select to select elements in Vue+Openlayer

Effect picture: Implementation code: <template...

HTML table tag tutorial (33): cell vertical alignment attribute VALIGN

In the vertical direction, you can set the cell a...