MySQL automatic Start up

[Sebioni]

Hi everyone,

I am creating a small intranet database for a client. I have installed MySql and Apache on their machine but I don't want them to have to manually start the MySQL engine every morning using the MS-dos window.

Does anyone know how I could start the MySQL engine when the computer boots? They are using Windows as their OS.

Any help would be greatly appreciated.

Cheers!

[Sebioni]

Come on,

One of you guys must know this. I can feel it....

[Mark T.]

If you are using this on an NT-box, which means Windows 2000 and Windows XP as well, you can use the following code:

C:\MySQL\bin\mysqld-nt --install

Run this code by clicking Start > Run and MySQL will be installed as a system service, and therefore start every time the pc boots.
You might need to change the path to MySQL accordingly, or even add a space between mysqld and -nt (for some reason I have to on my pc, still haven't figured out why ).

I hope that helps.

[Sebioni]

Thanks for that, Mark. However, they use Windows 98 and I am sure the command will be different.

Also, how do I stop this option once I have managed to start it when the computer boots? In other words, what is the command to stop MySQL start at start up?

Cheers

[martm]

one way is:

create a shortcut to your mysql program.

copy shortcut to 'C:\Windows\Start Menu\Programs\StartUp' folder. (assuming you installed windows in C:\Windows)

if you want to stop the program loading at startup, delete the shortcut.

hope this helps

[Sebioni]

For some reason, I was looking for a much more complicated solution. I was even messing up with the autoexec.bat file.

Thanks for pointing out a straight forward/easy solution.

Cheers

[RONIN-1]

Originally posted by Mark T.
If you are using this on an NT-box, which means Windows 2000 and Windows XP as well, you can use the following code:

C:\MySQL\bin\mysqld-nt --install

Run this code by clicking Start > Run and MySQL will be installed as a system service, and therefore start every time the pc boots.
You might need to change the path to MySQL accordingly, or even add a space between mysqld and -nt (for some reason I have to on my pc, still haven't figured out why ).

I hope that helps.

I am trying to run it on an NT 4 OS, and for some reason, it gives me an error stating that "could not start MySql service... then says Error 1067: the process terminated unexpectedly...

I'll try putting a space between the mysql and the -nt... and see if that works....

also, when i installed it on win 2k pro... i used

C:\MySQL\bin\mysqld-nt -install

does it make a difference if i used one dash "-" or two "--" ??