ccarper

I've had problems running MySql as a Service under XP, which I have
reduced down to two simple cases, one working, the other not. I
installed version 4.0.15 as c:\mysql (the recommended location) (and
confirmed the md5 checksum), and copied my-small.cnf from the default
location to c:\ as my.cnf (as recommended by the installer).

I can successfully install and start mysql as a service using these
commands:

mysqld --install
net start mysql

(I know the c:\my.cnf file is used because I can modify the file to
specify a different port and mysql will listen for connections on that
port.)

However, if I uninstall and reinstall the service, this time ********ly
specifying a defaults-file, mysql starts running but then dies without
yielding a clue:

mysqld --uninstall
mysqld --install mysql --defaults-file=c:\my.cnf
net start mysql

The output of the net start command is:

The service is not responding to the control function.

More help is available by typing NET HELPMSG 2186.

031012 14:45:20 InnoDB: Started
C:\mysql\bin\mysqld: ready for connections.
Version: '4.0.15-max-debug' socket: '' port: 3306


If I create trace files by adding "debug" to the my.cnf file, the two
trace files contain the same number of lines and do not appear to
contain significant differences. The last line in both the success and
failure cases is:

T@1 : | general: Waiting for connections.

Any suggestions on why specifying a defaults-file could trigger this
behavior would be greatly appreciated.

Craig Carper


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql-win32@freebsd.csie.nctu.edu.tw

eric.weidner

I have this same problem. =A0The service works in 4.0.14, but it seems to h=
ave=20
regressed in 4.0.15. =A0I had this problem with earlier 4.0.x releases as w=
ell.

Hopefully it will be fixed again in 4.0.16.

Eric

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dmysql-win32@freebsd.csie.nctu.edu.tw

paul

See: http://bugs.mysql.com/bug.php?id=1412

--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, http://www.mysql.com

Are you MySQL certified? http://www.mysql.com/certification/


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql-win32@freebsd.csie.nctu.edu.tw