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
Error 2003 can't connect to MySQL server on 'localhost' Solution: CMD Cd c:/MySQL/bin Mysqld-NT-Remove Mysqld-NT-install Net start MySQL Response Message Either the Server Service or the configuration file cocould not be found. startup variables and Service Section are therefore disabled. |
Cause of occurrence
When I manually installed MySQL, my. ini could not be correctly determined by the server. The service functions of the Management Tools MySQL administrator and MySQL query browser in MySQL GUI tools will be disabled.
Solution
On my computer, choose right> Management> services and applications> services> MySQL.
Path of the primary row: C:/program files (x86)/MySQL Server 5.0/bin/mysqld.exe MySQL
It must be modified:
"C:/program files (x86)/MySQL Server 5.0/bin/mysqld-nt" -- defaults-file = "C:/program files (x86) /MySQL Server 5.0/My. ini "MySQL
But it cannot be modified here. You need to modify it in the login Login login program.
Start> begin row> merge into Regedit> confirm
HKEY_LOCAL_MACHINE/system/CurrentControlSet/services/MySQL/ImagePath
After the change, the bug is fixed and you do not have to restart MySQL.