Bug #17715 Run as service is alwais C:\Mysql\bin\...
Submitted: 25 Feb 2006 6:39 Modified: 25 Feb 2006 7:17
Reporter: Alexander Selifonov Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.13, 5.0.18 OS:Windows (Windows XP)
Assigned to: MySQL Verification Team CPU Architecture:Any

[25 Feb 2006 6:39] Alexander Selifonov 
Description:
Regardless of installed directory service path is alwais "C:/MySQL/bin/mysqld-nt.exe"
So service cannot start until I fix this wrong path by REGEDIT.
This bug was in 4.1.13 and still exist in current 5.0.18 Setup.exe

How to repeat:
Just install into non-default directory, say "C:\app\mysql" and try to run as service

Suggested fix:
Check installer code
[25 Feb 2006 7:17] MySQL Verification Team 
Thank you for the bug report.
I was unable to repeat the behavior reported following the instructions
from the Manual when the install directory is a non-default one (to use
a configuration file c:\my.ini ir c:\windows\my.ini with the basedir and
datadir variables):

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

C:\Documents and Settings\miguel>cd\app\mysql\bin

C:\app\mysql\bin>mysqld-nt -V
mysqld-nt  Ver 5.0.18-nt for Win32 on ia32 (MySQL Community Edition (GPL))

C:\app\mysql\bin>mysqld-nt --install
Service successfully installed.

C:\app\mysql\bin>sc qc mysql
[SC] GetServiceConfig SUCCESS

SERVICE_NAME: mysql
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 2   AUTO_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : C:\app\mysql\bin\mysqld-nt MySQL
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : MySQL
        DEPENDENCIES       :
        SERVICE_START_NAME : LocalSystem

C:\app\mysql\bin>type c:\my.ini
[mysqld]
basedir=c:/app/mysql
datadir=c:/app/mysql/data

C:\app\mysql\bin>net start mysql

O serviço de MySQL foi iniciado com êxito.

C:\app\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.18-nt

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

mysql> show variables like "%basedir%";
+---------------+---------------+
| Variable_name | Value         |
+---------------+---------------+
| basedir       | c:\app\mysql\ |
+---------------+---------------+
1 row in set (0.00 sec)

mysql>