cannotcreatewindowsserviceformysql.error0解决方法集合

Cannot create Windows Service for MySQL.Error0 解决方法

集合

安装新的MYSLQ数据库，安装好运行MySQL Server Instance ConfigWizard，在最后一步却发现无法启动服务，出现这样的提示“cannotcreate windows service for

mysql.error:0”！

找了很久终于搞到一点资料，解决方法如下：

原因：

安装mysql时可能产生cannot create windows service formysql.error:0错误,错误的原因多数由于重新安装mysql或者对mydql升级,使用MySQLConfiguration Wizard而产生. 解决方法：

可以使用mysql以外的服务名,比如mysql11,等.但这不是最好的解决方法,我们可以使用windows的sc程序删除mysql 服务.

C:>sc delete mysql

[SC] DeleteService SUCCESS

再重新使用MySQL Configuration Wizard,就不会有此错误了。

如果还是不行,重新启动一下电脑就OK了

------------------------------------

附：sc的help

C:Documents and SettingsAdministrator>sc-?

*** Unrecognized Command ***

DESCRIPTION:

SC is a command line program used for communicating with the

NT Service Controller and services.

USAGE:

sc <server> [command] [service name]

<option1><option2>...

The option <server> has the form "/ServerName"

Further help on commands can be obtained by typing: "sc[command]"

Commands:

query-----------Queries the status for a service, or

enumerates the status for types of services.

queryex---------Queries the extended status for a service, or

enumerates the status for types of services.

start-----------Starts a service.

pause-----------Sends a PAUSE control request to a service.

interrogate-----Sends an INTERROGATE control request to aservice.

continue--------Sends a CONTINUE control request to aservice.

stop------------Sends a STOP request to a service.

config----------Changes the configuration of a service(persistant).

description-----Changes the description of a service.

failure---------Changes the actions taken by a service uponfailure.

qc--------------Queries the configuration information for aservice.

qdescription----Queries the description for a service.

qfailure--------Queries the actions taken by a service uponfailure.

delete----------Deletes a service (from the registry).

create----------Creates a service. (adds it to the registry).

control---------Sends a control to a service.

sdshow----------Displays a services security

descriptor.

sdset-----------Sets a services security descriptor.

GetDisplayName--Gets the DisplayName for a service.

GetKeyName------Gets the ServiceKeyName for a service.

EnumDepend------Enumerates Service Dependencies.

The following commands dont require a service name:

sc <server> <command> <option>

boot------------(ok | bad) Indicates whether the last bootshould

be saved as the last-known-good boot configuration

Lock------------Locks the Service Database

QueryLock-------Queries the LockStatus for the SCManagerDatabase

EXAMPLE:

sc start MyService

Would you like to see help for the QUERY andQUERYEX commands? [ y | n ]: y

QUERY and QUERYEX OPTIONS :