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

This article focuses on "the solution that the MySql service cannot be started". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Now let the editor to take you to learn the "MySql service can not start the solution" it!

1. Workaround where the service cannot be started the operating system:

Win xp phenomenon: mysql service failed to start

Exception message: unable to start mysql service on local computer error 1067: process aborted unexpectedly

Analyze the reason: there is no my.ini file in the C:\ WINDOWS directory. (if so, it is possible that the two environment variables basedir and datadir are mismatched.)

Solution: use the search method to find the my.ini file across the system, and if found, copy the file to the C:\ WINDOWS directory. If not, manually create the my.ini file in the C:\ WINDOWS directory, and the new file contains at least two basic configurations of basedir,datadir.

Example of my.ini configuration:

[mysqld]

# 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

At this point, I believe that you have a deeper understanding of the "solution that the MySql service cannot be started". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.