I have a problem installing mysql as a service under win2k pro.

mysql version : 3.23.47 basedir = d:/mysql

Here is what I did to install it : 1) installed into d:/mysql 2) ran mysqld-max-nt --install (runs fine, I can see it in the services console)

Please note that at this point there is neither a c:/my.cnf or d:/winnt/my.ini files.

When I start it with [net start mysql] or through the services console it fails with error 1067 (service failed unexpectedly). BUT, if I go into the services management console, double click to bring its properties dialog, put the following startup parameters [--basedir d:/mysql --skip-innodb] and hit start the service runs fine. I phpMyAdmin has no problem talking to the server and a mysqladmin variables works perfectly. This would be fine except that windows 2000 does not retain those parameters when you close the dialog by any way.

When I call the command line help of mysqld-max-nt it says my default basedir is d:/mysql and all ... From that I thought I only need --skip-innodb in the preceding procedure but no the service will not start if I omit either param.

I read all the comments about this specific problem in the manual and tried them all as you can see by the following tries :

0) I tried with no my.ini and no my.cnf files. NO SUCCESS 1) I tried making a c:/my.cnf (no my.ini) with just those 2 params. NO SUCCESS 2) I tried a d:/winnt/my.ini (no my.cnf) with just those 2 params. NO SUCCESS 3) Tried both with these 2 params. NO SUCCESS 4) Tried creating a c:/my.cnf based on my-example.cnf and changing the directory values for d:/ instead of c:/ and uncommenting skip-innodb. NO SUCCESS 5) same as above but with my.ini and no my.cnf. NO SUCCESS 6) both a my.ini and my.cnf with example configuration modified. NO SUCCESS

..... O and dont even think about asking me if I have rebooted! ;-)

I'm rather stumped and would appreciate any help...

Sylvain