Cannot create Windows Service for MySQL.Error:0 解决方法集合

 http://qqhugo.blogbus.com/logs/15733455.html

安装新的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