Using WinXP Home's "Computer Management" utility (which you get via:
Start / Settings / Control Panel / Administrative Tools / Computer Management), I can see, under "Services and Applications" / Services, that MySQL's "startup type" is "Automatic". I didn't set this so apparently this is what happens automatically on normal install of MySQL onto WinXP Home (or maybe on running WinMySQLAdmin the first time). The command being run is "C:\mysql\bin\mysqld-nt". I want to have manual startup/shutdown but still am not sure of the appropriate way to do this. The "Computer Management" utility allows me to stop the service and/or change the service startup type to manual or "disabled." Is "disabled" the same as removing the service? Is there some other way to have the MySQL server running on a standalone Win system other than as a service? Which way is appropriate for standalone? Given that I want manual startup and shutdown and am running standalone, should I disable/remove the service? After doing that, how should I start and stop the server? The manual says that under NT you do: NET START mysql NET STOP mysql but only when mysqld is installed as a service. ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; "Gerald R. Jensen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "Ed Carp" <[EMAIL PROTECTED]> Sent: Wednesday, September 11, 2002 11:04 AM Subject: Re: Default Win install --> mySQL autostarts when booting? At 10:43 +0800 9/11/02, Uriel Wittenberg wrote: >Sorry for not specifying: I'm using WinXP HOME. > >I did the normal default install. It seems to start up the mySQL server >automatically when I start up Windows. Hence my question: > >Is there a standard way to change that so the server only runs when >explicitly invoked? Start the Services Manager and see if it lists an entry for the "MySql" service. If so, tell the service to stop and close the window. Then open a DOS window and issue this command: C:\> mysqld --remove That will remove the service. Then it will run only when you invoke it explicitly. Alternatively, if the service is registered, you can change it to be a "manual" service rather than an "automatic" service. Then you use the Services Manager to start it up as a service, but you have to do so yourself. It won't start whenever Windows starts. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php