MySQL Bugs: #4746: this error should be given attention

Bug #4746	this error should be given attention
Submitted:	25 Jul 2004 18:08	Modified:	25 Jul 2004 21:10
Reporter:	Dennis Rodriguez	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.0	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

Description:
The MySQL Server could not be started
A System Error has occured
System Error 1067 has occured
The process terminated unexpectedly

it always happen when i try to start the MySQL either by clicking the start button in the services or using the command line by typing the net start mysql but i can install the mysql as service but it doesn't start automatically thou the status type column indicated that the service will run automatically but the status remains blanck and when i ever try to click on the start button or start link label i always got an error as stated above but i can use the mysqld --console with no problem and i can connect to the mysql using the MySq Administrator GUI when i typed the mysqld --console in the command prompt window.

btw: I have a SQL Server 2000 running on my pc could that be a problem?

How to repeat:
install the mysql as service and run the net start mysql under the command prompt or click on the service name and then click the start link located at the left corner of services window or double click the service name and then click on the start button.

Hi,

I wasn't able to repeat the behavior reported:

Microsoft Windows XP [versão 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

c:\mysql\bin>mysqld-nt --install-manual
Service successfully installed.

c:\mysql\bin>net start mysql
O serviço de MySQL está sendo iniciado.
O serviço de MySQL foi iniciado com êxito.

c:\mysql\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.0-alpha-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Additional Info:

The error 1067 generally happens when the server aborts
for a wrong configuration key.
Verify if you have the below similar keys in your my.ini file:

[mysqld]
basedir=c:/mysql
datadir=c:/mysql/data

also please verify in the mysql.err file for any error message:

c:\mysql\bin>type c:\mysql\data\mysql.err
MySQL: ready for connections.
Version: '5.0.0-alpha-nt'  socket: ''  port: 3306