Mysql service can't start 1067 error resolution

  
                  

Regardless of the version of mysql installed, when the mysql service is started in the service of the management tool, it will report an error in the middle. The content is: The local computer cannot start the mysql service Error 1067: The process aborted unexpectedly.

After many parties, the solution is as follows:

Search the system (later verified that it should be the windows directory) directory my.ini file, edit the content (if there is no such file, create a new one) At least two basic configurations, basedir and datadir.

[mysqld]

# set basedir to installation path, eg, c:/mysql
# Set to MYSQL installation directory
basedir=D:/www/WebServer/MySQL
# set datadir to location of data directory,
# eg, c:/mysql/data or d:/mydata/data
# Set to MYSQL data directory
datadir=D:/Www/WebServer/MySQL/data

In addition, the idea is

[WinMySQLadmin]
Server=D:/www/WebServer/MySQL/bin/mysqld-nt.exe
User=root
password=xxxxxxxx
#The above is to set the configuration of WinMySQLadmin
[Client]
user=root
password=xxxxxxxx

hehe~ :) Solved < Br>

my.ini file content is as follows. I changed it myself, just fine, 嘿嘿

[mysqld]
# set basedir to installation path, eg, D:/mysql
# Set to MYSQL installation directory
basedir=D:/mysql
# set datadir to location of data directory,
# eg, d:/mysql/data or d:/mysql/mydata/data < BR># Set to MYSQL data directory
datadir=D:/MySQL/data

Copyright © Windows knowledge All Rights Reserved