MySQL on Win. XP

[nsr81]

I want to install mysql on XP, you know for testing my scripts and stuff. What do you guys recommend, install as a service, or stand alone. Pros/cons? etc. etc.

[lemon]

Where in MySQL installation for Windows did you find this option?

Sorry if I don't understand something...

[ATipsy]

You install MySQL as a service in Win NT/2000 from the command line. I don't think that it's an option when you're installing it. Just run the NT binary with the --install switch like this:

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

(of course you have need to change the path)

Then you can stop and start the service with the following

C:\> NET START mysql
C:\> NET STOP mysql

But, I always just use the Services Manager for doing such things. I just made it so that it starts on boot on my development box. I also did the same thing for Apache.

Go to http://www.mysql.com/doc/N/T/NT_start.html for more details

[ATipsy]

As for your question about PROS/CONS of Service vs. Stand Alone ...... I really can't think of any cons of running it as a service .... unless you have some kind of security reservations about MySQL running when you're not using it.

The only other issue is when you run it as a service you can't specify any other command line options (like --debug). If you want to do such things you must specify them as Startup parameters in the Services Manager before you start the MySQL service.

I choose to run it as a service out of convience .... so that I don't have to start it everytime I want to do something. I also try to minimize things on my taskbar and systray :cool: