Bug #3670 Unable to start service on Windows 2000 SP4
Submitted: 5 May 2004 23:46 Modified: 6 May 2004 22:47
Reporter: Darrell Duffy Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:4.0.18 OS:Microsoft Windows (Windows 2000 SP4)
Assigned to: CPU Architecture:Any

[5 May 2004 23:46] Darrell Duffy
Description:
I've installed MySQL 4.0.18. Windows 2000 SP4.

It works if I start MySQL in a console window with mysqld --console
The service installs without error and appears in the service list.
The path to exe in service properties is:
"C:\Program Files\mysql\bin\mysqld" MySQL
But when I start it, I get:
Could not start MySQL Service on Local Computer.
Error 1067: Process Terminates Unexpectedly.

I have tried to change the log in user and set or cleared the "allow service to interact with desktop".
Still same error.

It is obviously important to run as service so that MySQL is avaiable when system is unattended.

Thanks,
djd

How to repeat:
See description...
[6 May 2004 15:32] Miguel Solorzano
Verify your \winnt\my.ini or c:\my.cnf for to
have the keys set like showed below:

C:\Arquivos de programas\mysql\bin>mysqld --install
Service successfully installed.

C:\Arquivos de programas\mysql\bin>type d:\win\my.ini
[mysqld]
basedir="c:/arquivos de programas/mysql"
datadir="c:/arquivos de programas/mysql/data"

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

C:\Arquivos de programas\mysql\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.18-max-debug

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

mysql>
[6 May 2004 17:55] Darrell Duffy
Thanks very much.

Apparently the installer does not create the my.ini file.
I created it in C:\WINNT\ and added the three lines as suggested and all is well.

Apparently the installer should create this file and populate it as indicated.

djd
[6 May 2004 22:47] Sergei Golubchik
Usually, MySQL does not require mi.ini file, and works with default settings, that's why the installer does not create it.

My guess is that you installed MySQL in non-standard location so that built-in defaults do not work. In this case you need mi.ini.