No matter what version of mysql is installed, an error will be reported midway through the mysql service in the management tool. Content: unable to start mysql service on local computer error 1067: Process aborted unexpectedly.
The solution is as follows:
Find my. INI file, edit the content (if the file does not exist, create a new one), including at least two basic configurations: basedir and datadir.
[Mysqld]
# Set basedir to installation path, e.g., c:/mysql
# Set it to the MYSQL installation directory
Basedir = D:/www/WebServer/MySQL
# Set datadir to location of data directory,
# E.g., c:/mysql/data or d:/mydata/data
# Set it to the MYSQL DATA DIRECTORY
Datadir = D:/www/WebServer/MySQL/data
In addition, you need an idea
[WinMySQLadmin]
Server = D:/www/WebServer/MySQL/bin/mysqld-nt.exe
User = root
Password = xxxxxxxx
# The above is the configuration for setting WinMySQLadmin
[Client]
User = root
Password = xxxxxxxx
Hehe ~ :) Solved
The content of my. ini file is as follows. I just changed it myself.
[Mysqld]
# Set basedir to installation path, e.g., D:/mysql
# Set it to the MYSQL installation directory
Basedir = D:/mysql
# Set datadir to location of data directory,
# E.g., d:/mysql/data or d:/mysql/mydata/data
# Set it to the MYSQL DATA DIRECTORY
Datadir = D:/MySQL/data