Re: Default Win install -- mySQL autostarts when booting?

2002-09-11 Thread Alec . Cawley



 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?

2002-09-10 Thread Uriel Wittenberg

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?

2002-09-10 Thread Gerald R. Jensen

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?

2002-09-10 Thread Paul DuBois

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?

2002-09-10 Thread Gerald R. Jensen

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?

2002-09-10 Thread Ed Carp

 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?

2002-09-10 Thread Uriel Wittenberg

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?

2002-09-10 Thread Paul DuBois

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