Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the 1067 error in the startup of Mysql service". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn how to solve the 1067 error in the startup of Mysql service.

No matter what version of mysql is installed, an error will be reported halfway when starting the mysql service in the administrative tools service. The content is: unable to start mysql service on the local computer error 1067: the process aborted unexpectedly.

The solution is as follows

Find the my.ini file in the system (later verified to be a directory) directory, edit the contents (if not, create a new one), and include at least the two basic configurations of basedir,datadir.

[d]

# set basedir to installation path, e.g., c:/mysql

# set to the installation directory of MYSQL

Basedir=D:/www/WebServer/MySQL

# set datadir to location of data directory

# e.g., c:/mysql/data or d:/mydata/data

# set to the data directory of MYSQL

Datadir=D:/www/WebServer/MySQL/data

Besides, you need an idea.

[WinMySQLadmin]

Server=D:/www/WebServer/MySQL/bin/mysqld-nt.exe

User=root

Password=xxxxxxxx

# above are the configurations for setting WinMySQLadmin

[Client]

User=root

Password=xxxxxxxx

Hehe~ solved

The contents of the my.ini file are as follows. I changed it myself. I'll be fine. Hey, hey.

[mysqld]

# set basedir to installation path, e.g., D:/mysql

# set to the installation directory of MYSQL

Basedir=D:/mysql

# set datadir to location of data directory

# e.g., d:/mysql/data or d:/mysql/mydata/data

# set to the data directory of MYSQL

Datadir=D:/MySQL/data

Thank you for your reading, the above is the "Mysql service startup error 1067 how to solve" content, after the study of this article, I believe you have a deeper understanding of how to solve the problem of Mysql service startup error 1067, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.