Bug #18687 my
Submitted: 31 Mar 2006 13:07 Modified: 30 Apr 2006 13:30
Reporter: evergreen lee Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.18 OS:Windows (windows server 2000 (chs))
Assigned to: Assigned Account CPU Architecture:Any

[31 Mar 2006 13:07] evergreen lee
Description:
My dearest:
   I installed MYSQL 5.0.18 on Windows Server 2000 (chinese simpified version) 
using a binary distribution and expected it running as a Windows service.but MYSQL
is not running,the MYSQL process is not present,when I check my operating system'
process list.Two errores are shown,when I open utility log window.The first error 
is "C:\program file\mysql\mysql server 5.0\bin\mysqld-nt:Get signal 11.Aborting!"
.Another error is "Aborting".Both event ID is 100.
   A warning " 在本地计算机上无法启动MYSQL服务。错误1067:进程意外终止。(you 
cannot start the MYSQL server on the local computer .error 1067:process 
surprisedly end)",when I open a "Windows'server" window and start a MYSQL server.
   "MYSQL Administrator Error"window is present."Could not connect to the specified 
instance 。MYSQL Error Number 2003.Can't connect to MYSQL Server on 'localhost'
[10061],if you want to check the network connection,please click the ping button."
when I try to connect to the MYSQL server via MYSQL Administrator.
    I read MYSQL Manual very carefully,and I try to repair it many times.so far,
this problem cannot still be solved. Could you help me find out what the problem
is and how to solve this problem.My E-mail address is leeevergreen@21cn.com

    Thanks!
                                            yours
                                                          leeevergreen
亲爱的朋友:
     我在WINDOWS SERVER 2000(中文简体版)安装了MYSQL 5.0,使用的是二进制发行版。并
且期待它作为WINDOWS的一个服务运行。但是MYSQL 并不运行,当我检查我的操作系统进程表
时,MYSQL进程没有出现在该表中。当我打开应用程序日志窗口时,出现了两个错误:一 "C:
\program file\mysql\mysql server 5.0\bin\mysqld-nt:Get signal 11.Aborting!"
.Another error is "Aborting(获取信号11。失败退出)".两个事件的标志都是100。
     当我打开一个WINDOWS服务窗口并且启动MYSQL服务时,出现一个警告:“在本地计算
机上无法启动MYSQL服务。错误1067:进程意外终止。”
     当我试图通过MYSQL ADMINISTRATOR 连接到MYSQL服务器时,一个错误出现:不能连接
到指定的实例。MYSQL错误号2003。不能在本地计算机连接到MYSQL服务器[10061]。如果
你想检查网络连接,请点击PING按钮。
  我仔细地阅读了MYSQL手册,并多次试图修复它。到现在为止,难题仍未解决。您能帮我
找出问题,和如何解决这个问题。我的E_MAIL地址是:leeevergreen@21cn.com
  感谢您的帮助!
                                                             李生

How to repeat:
My dearest:
   I installed MYSQL 5.0.18 on Windows Server 2000 (chinese simpified version) 
using a binary distribution and expected it running as a Windows service.but MYSQL
is not running,the MYSQL process is not present,when I check my operating system'
process list.Two errores are shown,when I open utility log window.The first error 
is "C:\program file\mysql\mysql server 5.0\bin\mysqld-nt:Get signal 11.Aborting!"
.Another error is "Aborting".Both event ID is 100.
   A warning " 在本地计算机上无法启动MYSQL服务。错误1067:进程意外终止。(you 
cannot start the MYSQL server on the local computer .error 1067:process 
surprisedly end)",when I open a "Windows'server" window and start a MYSQL server.
   "MYSQL Administrator Error"window is present."Could not connect to the specified 
instance 。MYSQL Error Number 2003.Can't connect to MYSQL Server on 'localhost'
[10061],if you want to check the network connection,please click the ping button."
when I try to connect to the MYSQL server via MYSQL Administrator.
    I read MYSQL Manual very carefully,and I try to repair it many times.so far,
this problem cannot still be solved. Could you help me find out what the problem
is and how to solve this problem.My E-mail address is leeevergreen@21cn.com

    Thanks!
                                            yours
                                                          leeevergreen
亲爱的朋友:
     我在WINDOWS SERVER 2000(中文简体版)安装了MYSQL 5.0,使用的是二进制发行版。并
且期待它作为WINDOWS的一个服务运行。但是MYSQL 并不运行,当我检查我的操作系统进程表
时,MYSQL进程没有出现在该表中。当我打开应用程序日志窗口时,出现了两个错误:一 "C:
\program file\mysql\mysql server 5.0\bin\mysqld-nt:Get signal 11.Aborting!"
.Another error is "Aborting(获取信号11。失败退出)".两个事件的标志都是100。
     当我打开一个WINDOWS服务窗口并且启动MYSQL服务时,出现一个警告:“在本地计算
机上无法启动MYSQL服务。错误1067:进程意外终止。”
     当我试图通过MYSQL ADMINISTRATOR 连接到MYSQL服务器时,一个错误出现:不能连接
到指定的实例。MYSQL错误号2003。不能在本地计算机连接到MYSQL服务器[10061]。如果
你想检查网络连接,请点击PING按钮。
  我仔细地阅读了MYSQL手册,并多次试图修复它。到现在为止,难题仍未解决。您能帮我
找出问题,和如何解决这个问题。我的E_MAIL地址是:leeevergreen@21cn.com
  感谢您的帮助!
                                                             李生
[31 Mar 2006 13:30] MySQL Verification Team
Thank you for the bug report.
The easy way to see why the service is aborting is to try to
start the server as standalone from a DOS prompt and to
see the error messages.
Then verify if exists an my.ini file in the installation directory
and keep in mind its path. Then execute the below command:

mysqld-nt --defaults-file=path_my.ini --standalone --console

and see the error message. Please post here the error in English.

Thanks in advance.
[1 May 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[29 May 2006 12:57] Liu xuanyu
I am often find the same quetions from mysql5.0.* version. Now I am using windows 2003 and mysql 5.0.21. when restart windows system, then mysql cant   connect."  Can't connect to MySQL server on 'localhost' (10061)" .

but I am saw mysql service started run. 

So I have try use dos command E:\MySQL5\bin\mysqld --console. and see some informations. and just mysql can work . but I close the dos command window after, mysql down and cant work again.

please see the photo. 

The questions have been many times and ask for friends help. but mysql still happen the wrong. 

Plese tell me how i do it. ?!  

Thanks

--Liu.
info_yon at yahoo.com.cn
[29 May 2006 13:11] Liu xuanyu
This is my use --console command after mysql will work. but when i close the command mysql still cant right work.  Using Mysql 5.0.21 

http://yon.ongod.org/bugreport/mysql5021.jpg