重装mysql后出现"cannot create windows service for mysql.error:0"错误
来源:互联网 发布:中英文对照软件 编辑:程序博客网 时间:2024/05/16 12:29
重装了mysql,装完后无法启动服务,显示“cannot create windows service formysql.error:0”,那时刚学mysql时好像也碰到过这样的问题,当时很模糊,莫名其妙的弄好了。现在理解了这个问题,因为系统中原先存在的“mysql”服务与新安装的mysql所创建的服务重名,导致新安装的mysql服务无法创建,只要把原先没用的“mysql”服务删除就ok了。
PS:学到了一招,windows中的sc程序可以用来管理系统服务,用它来删服务很方便,以前都去regedit里删的说。
参考资料如下,转自这里
----------------------------------
安装新的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 :
If the query command is followed by a service name, thestatus
for that service is returned. Further options donot apply in
this case. If the query command is followed bynothing or one of
the options listed below, the services are enumerated.
type= Type ofservices to enumerate (driver, service, all)
(default = service)
state= State of services toenumerate (inactive, all)
(default = active)
bufsize= Thesize (in bytes) of the enumeration buffer
(default = 4096)
ri= The resume index number at which to begin the enumeration
(default = 0)
group= Service group toenumerate
(default = all groups)
SYNTAX EXAMPLES
scquery - Enumerates status for active services & drivers
sc querymessenger - Displays status for the messenger service
sc queryexmessenger -Displays extended status for the messenger service
sc query type= driver -Enumerates only active drivers
sc query type= service - Enumerates only Win32services
sc query state=all - Enumerates all services & drivers
sc query bufsize=50 -Enumerates with a 50 byte buffer.
sc query ri=14 - Enumerates with resume index = 14
sc queryex group="" -Enumerates active services not in a group
sc query type= service type= interact - Enumerates all interactiveservices
sc query type= driver group=NDIS - Enumerates all NDIS drivers
转自: http://qqhugo.blogbus.com/logs/15733455.html
- 重装mysql后出现"cannot create windows service for mysql.error:0"错误
- mysql错误:cannot create windows service for mysql.error:0
- MySQL重装-cannot create windows service for mysql
- 关于MySQL的卸载后重装(Cannot create Windows service for MySql等问题)
- Error: Cannot create Windows service for MySql. Error: 0解决方案
- 安装MySQL出现Cannot create windows service for mysql.error:0解决方案
- 解决安装MySQL出现Cannot create windows service for mysql.error:0
- cannot create windows service for mysql. error 0—mysql启动错误1067的解决
- Cannot create Windows Service for MySQL.Error:0 解决方法集合
- cannot create windows service for mysql.error:0
- Cannot create windows service for mysql.error:0
- Cannot create Windows Service for MySQL.Error:0 解决方法
- cannot create windows service for mysql.error:0
- cannot create windows service for mysql error 0 解决办法
- 解决安装MySQL5.1出现Cannot create windows service for mysql.error:0
- 解决安装MySQL5.1出现Cannot create windows service for mysql.error:0
- Cannot create windows service for mysql.error:0 (解决安装MYSQL5出现问题)
- 解决安装MySQL5.1出现Cannot create windows service for mysql.error:0
- Android简明开发教程十:数据绑定Data Binding
- JTable's Bug
- ubuntu中一些环境变量配置
- 浅谈C#编程 泛型编程的好处
- 主板sata设置成ide装的win7,再调回ahci就需要重装吗?
- 重装mysql后出现"cannot create windows service for mysql.error:0"错误
- 【淘宝SEO】论坛推广的6个方法及注意事项
- ifconfig 详解
- Using the Code Coverage Tools from the Command Line
- 解决VM开机时vmware开机提示驱动器未就绪
- Unable to execute dex: wrapper was not properly loaded first
- 【转】C++指向类成员的指针的使用(详细介绍)
- 【转】C++指向类成员的指针的使用(详细介绍)
- B/S