Re: Default Win install -- mySQL autostarts when booting?
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? I think the WinMySQLAdmin program automatically installs MySQL as a service the first time it is started up. Since this is a natural thing to do after running the install script, one tends to get the service without realising it. The same tool will allow you to uninstall the service and (I think) start it manually once installed. There are many other ways of achieving the same effect, some of which Paul has already explained. Alec Cawley - 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
Default Win install -- mySQL autostarts when booting?
Does a normal WinXP installation of WinXP result in the mySQL server being automatically started up whenever one boots up the system? If so this is not well documented and it's not an appropriate default, at least not for everyone. Is there a standard way to change that so the server only runs when explicitly invoked? - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Uriel Wittenberg [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 11:59 PM Subject: Re: Confused, discombobulated, weirded out, upset! --Windows standalone user Then does a normal Windows installation set it up so the server autostarts whenever you boot up? I did not manually start the server. It might be installed as a service. - finishing up previous topic: --- I don't understand. In your previous message, you said: At 23:37 +0800 9/10/02, Uriel Wittenberg wrote: Also, per advice here, I tried putting local-infile=1 in the [mysqld] and [mysql] sections of my.cnf(my.ini), but that does not change the behavior. Which seems to contradict what you're saying now. Yes, sorry -- I corrected my error in a previous message in this thread. - 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
Re: Default Win install -- mySQL autostarts when booting?
Which version of WinXP (Pro or Home)? On WinXP Pro, you'd have to install MySQL as a service, in which case it can either started manually or automatically. WinXP Home is more like WinME (yuck!) or Win98, where you can start MySLQ from a batch file. - Original Message - From: Uriel Wittenberg [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 6:14 PM Subject: Default Win install -- mySQL autostarts when booting? Does a normal WinXP installation of WinXP result in the mySQL server being automatically started up whenever one boots up the system? If so this is not well documented and it's not an appropriate default, at least not for everyone. Is there a standard way to change that so the server only runs when explicitly invoked? - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Uriel Wittenberg [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 11:59 PM Subject: Re: Confused, discombobulated, weirded out, upset! --Windows standalone user Then does a normal Windows installation set it up so the server autostarts whenever you boot up? I did not manually start the server. It might be installed as a service. - finishing up previous topic: --- I don't understand. In your previous message, you said: At 23:37 +0800 9/10/02, Uriel Wittenberg wrote: Also, per advice here, I tried putting local-infile=1 in the [mysqld] and [mysql] sections of my.cnf(my.ini), but that does not change the behavior. Which seems to contradict what you're saying now. Yes, sorry -- I corrected my error in a previous message in this thread. - 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 - 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
Re: Default Win install -- mySQL autostarts when booting?
At 18:47 -0500 9/10/02, Gerald R. Jensen wrote: Which version of WinXP (Pro or Home)? On WinXP Pro, you'd have to install MySQL as a service, ??? Have to, or have the option to? in which case it can either started manually or automatically. WinXP Home is more like WinME (yuck!) or Win98, where you can start MySLQ from a batch file. - Original Message - From: Uriel Wittenberg [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 6:14 PM Subject: Default Win install -- mySQL autostarts when booting? Does a normal WinXP installation of WinXP result in the mySQL server being automatically started up whenever one boots up the system? If so this is not well documented and it's not an appropriate default, at least not for everyone. Is there a standard way to change that so the server only runs when explicitly invoked? - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Uriel Wittenberg [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 11:59 PM Subject: Re: Confused, discombobulated, weirded out, upset! --Windows standalone user Then does a normal Windows installation set it up so the server autostarts whenever you boot up? I did not manually start the server. It might be installed as a service. - 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
RE: Default Win install -- mySQL autostarts when booting?
You are right, Paul ... the service is optional on WinXP Pro. I'm a creature of habit! -Original Message- From: Paul DuBois [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 7:32 PM To: Gerald R. Jensen; Uriel Wittenberg; [EMAIL PROTECTED] Subject:Re: Default Win install -- mySQL autostarts when booting? At 18:47 -0500 9/10/02, Gerald R. Jensen wrote: Which version of WinXP (Pro or Home)? On WinXP Pro, you'd have to install MySQL as a service, ??? Have to, or have the option to? in which case it can either started manually or automatically. WinXP Home is more like WinME (yuck!) or Win98, where you can start MySLQ from a batch file. - Original Message - From: Uriel Wittenberg [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 6:14 PM Subject: Default Win install -- mySQL autostarts when booting? Does a normal WinXP installation of WinXP result in the mySQL server being automatically started up whenever one boots up the system? If so this is not well documented and it's not an appropriate default, at least not for everyone. Is there a standard way to change that so the server only runs when explicitly invoked? - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Uriel Wittenberg [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 11:59 PM Subject: Re: Confused, discombobulated, weirded out, upset! --Windows standalone user Then does a normal Windows installation set it up so the server autostarts whenever you boot up? I did not manually start the server. It might be installed as a service. - 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
Re: Default Win install -- mySQL autostarts when booting?
Which version of WinXP (Pro or Home)? On WinXP Pro, you'd have to install MySQL as a service, in which case it can either started manually or automatically. WinXP Home is more like WinME (yuck!) or Win98, where you can start MySLQ from a batch file. WinXP Home is MUCH more stable than ME ever dreamed of being. And yes, you can run services under XP Home. sql, query - 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
Re: Default Win install -- mySQL autostarts when booting?
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? - Original Message - From: Gerald R. Jensen [EMAIL PROTECTED] To: Uriel Wittenberg [EMAIL PROTECTED]; [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 7:47 AM Subject: Re: Default Win install -- mySQL autostarts when booting? Which version of WinXP (Pro or Home)? On WinXP Pro, you'd have to install MySQL as a service, in which case it can either started manually or automatically. WinXP Home is more like WinME (yuck!) or Win98, where you can start MySLQ from a batch file. - Original Message - From: Uriel Wittenberg [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 6:14 PM Subject: Default Win install -- mySQL autostarts when booting? Does a normal WinXP installation of WinXP result in the mySQL server being automatically started up whenever one boots up the system? If so this is not well documented and it's not an appropriate default, at least not for everyone. Is there a standard way to change that so the server only runs when explicitly invoked? - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Uriel Wittenberg [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 11:59 PM Subject: Re: Confused, discombobulated, weirded out, upset! --Windows standalone user Then does a normal Windows installation set it up so the server autostarts whenever you boot up? I did not manually start the server. It might be installed as a service. - finishing up previous topic: --- I don't understand. In your previous message, you said: At 23:37 +0800 9/10/02, Uriel Wittenberg wrote: Also, per advice here, I tried putting local-infile=1 in the [mysqld] and [mysql] sections of my.cnf(my.ini), but that does not change the behavior. Which seems to contradict what you're saying now. Yes, sorry -- I corrected my error in a previous message in this thread. - 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 - 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 - 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
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. - Original Message - From: Gerald R. Jensen [EMAIL PROTECTED] To: Uriel Wittenberg [EMAIL PROTECTED]; [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 7:47 AM Subject: Re: Default Win install -- mySQL autostarts when booting? Which version of WinXP (Pro or Home)? On WinXP Pro, you'd have to install MySQL as a service, in which case it can either started manually or automatically. WinXP Home is more like WinME (yuck!) or Win98, where you can start MySLQ from a batch file. - Original Message - From: Uriel Wittenberg [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 6:14 PM Subject: Default Win install -- mySQL autostarts when booting? Does a normal WinXP installation of WinXP result in the mySQL server being automatically started up whenever one boots up the system? If so this is not well documented and it's not an appropriate default, at least not for everyone. Is there a standard way to change that so the server only runs when explicitly invoked? - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Uriel Wittenberg [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 11:59 PM Subject: Re: Confused, discombobulated, weirded out, upset! --Windows standalone user Then does a normal Windows installation set it up so the server autostarts whenever you boot up? I did not manually start the server. It might be installed as a service. - finishing up previous topic: --- I don't understand. In your previous message, you said: At 23:37 +0800 9/10/02, Uriel Wittenberg wrote: Also, per advice here, I tried putting local-infile=1 in the [mysqld] and [mysql] sections of my.cnf(my.ini), but that does not change the behavior. Which seems to contradict what you're saying now. Yes, sorry -- I corrected my error in a previous message in this thread. - 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 - 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 - 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 - 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