MySQL Service won't start cuz of an error

[Firemyst]

Hi there,

I have MySQL installed on a W2K server. The "service" was installed, but now will not start when my machine starts up.

I receive the following in the event log:

-----
The MySql service failed to start due to the following error:
The system cannot find the path specified.
-----

How do I:
1) Uninstall the service (running the MySQL Uninstall doesn't do it) OR
2) where is the path I need to fix? If it's in the registry, which registry key is it?

Thanks!

 

[sleipnir214]

MySQL does not use the registry. It uses a file called my.cnf as its configuration file -- I take it you did not create one when you installed MySQL.

Take a look here about half-way down the page:

http://www.mysql.com/doc/en/Windows_prepare_environment.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Firemyst]

I did read that. I can't use the "my.cnf" because my boot drive is drive "D" and NOT drive "C". MySQL is located in my F:/Inetpub/MySQL folder.

According to the link you sent me (as well as the MYSQL docs), I need to use only my.ini in the D:/WINNT folder.

It's there and doesn't work.

The MySQL docs also say to try the my.cnf. I tried placing that in the D:/ folder, D:/WinNT, and F:/INetpub/MySQL folders.

No luck either way.

The MYSQL docs also say to edit the values in the registry (this is an exact copy/paste from the HTML docs. NOTE the last line of fixing the path in the registry!) :

--------------------

Note that in this case you can't use any other options for mysqld-nt!

You can also run mysqld-nt as a stand-alone program on NT if you need to start mysqld-nt with any options! If you start mysqld-nt without options on NT, mysqld-nt tries to start itself as a service with the default service options. If you have stopped mysqld-nt, you have to start it with NET START mysql.

The service is installed with the name MySQL. Once installed, it must be started using the Services Control Manager (SCM) Utility found in the Control Panel, or by using the NET START MySQL command. If any options are desired, they must be specified as ``Startup parameters'' in the SCM utility before you start the MySQL service. Once running, mysqld-nt can be stopped using mysqladmin, or from the SCM utility or by using the command NET STOP MySQL. If you use SCM to stop mysqld-nt, there is a strange message from SCM about mysqld shutdown normally. When run as a service, mysqld-nt has no access to a console and so no messages can be seen.

On NT you can get the following service error messages:
Permission Denied Means that it cannot find mysqld-nt.exe.
Cannot Register Means that the path is incorrect.
Failed to install service. Means that the service is already installed or that the Service Control Manager is in bad state.

If you have problems installing mysqld-nt as a service, try starting it with the full path:

C:\> C:\mysql\bin\mysqld-nt --install

If this doesn't work, you can get mysqld-nt to start properly by fixing the path in the registry!

----------------------

Any other ideas?

 

[sleipnir214]

Try putting my.cnf in the root of C:, regardless of the drive from which you boot.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Firemyst]

I don't have a C drive. The only drives I have on my server are "D" (where the OS is installed) and "F" (where all the web apps, inetpub, and mysql are installed).

I've already tried in the root "D" drive folder, and it doesn't work.

Any other ideas?

 

[sleipnir214]

I've always placed my.cnf in the root of C:, and it's always worked. The thing is, MySQL on Win32 is pretty picky about the location of the configuration files.

I'm worried that with no C: drive at all MySQL may not be able to ever find the configuration files it needs.

I'm going to bow out -- I hope someone else can pick this up and help you.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!