1. Solution to mysql service failure operating system:
Win xp: mysql service cannot be started
Exception message: mysql service cannot be started on the local computer. Error 1067: Process aborted unexpectedly
Cause: the my. ini file does not exist in the C: \ WINDOWS directory. (If yes, the two environment variables basedir and datadir may have an error ).
Solution: use the search method to search for the my. ini file in the entire system. If yes, copy the file to the C: \ WINDOWS directory. If not, manually create the my. ini file in the C: \ WINDOWS directory. The new file contains at least two basic configurations: basedir and datadir.
My. ini configuration example:
[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