I don't think this makes sense either, but you will see what I mean:
FOR MY ADMIN ACCOUNT
C:\>netstat -a -p tcp
Active Connections
Proto Local Address Foreign Address State
TCP dynamic:http dynamic:0 LISTENING
TCP dynamic:epmap dynamic:0 LISTENING
TCP dynamic:microsoft-ds dynamic:0 LISTENING
TCP dynamic:1025 dynamic:0 LISTENING
TCP dynamic:1027 dynamic:0 LISTENING
TCP dynamic:1031 dynamic:0 LISTENING
TCP dynamic:3306 dynamic:0 LISTENING
TCP dynamic:1031 dynamic:3306 ESTABLISHED
TCP dynamic:3306 dynamic:1031 ESTABLISHED
TCP dynamic:netbios-ssn dynamic:0 LISTENING
FOR THE REGULAR USER ACCOUNT
C:\>netstat -a -p tcp
Active Connections
Proto Local Address Foreign Address State
TCP dynamic:http dynamic:0 LISTENING
TCP dynamic:epmap dynamic:0 LISTENING
TCP dynamic:microsoft-ds dynamic:0 LISTENING
TCP dynamic:1025 dynamic:0 LISTENING
TCP dynamic:1027 dynamic:0 LISTENING
TCP dynamic:3306 dynamic:0 LISTENING
TCP dynamic:netbios-ssn dynamic:0 LISTENING
I was under the impression that once something is installed as a
service, it is available to the system for all users. This is not the
case here. In fact, once I log off admin and onto the other accounts
the winmysqladmin manager (which I put in startup for all users) asks if
I want to install the service!!! When I click "OK" it says "install
failed" and I actually have to shut down the tool in order to log off
(or else the system hangs). My web site can connect to the server using
PHP scripts to grab data with no problems when the admin account is
running, but as soon as I log off and on to another account the dynamic
part of the site dies.
Again, when I was on my admin account I installed the MySQL service from
the command prompt using:
mysqld-nt --install
and the result was "service has been installed" (paraphrasing). I have
uninstalled MySQL completely and reinstalled only to run into the same
problem. I'm using the 3.23.49 binary package.
-Kirk
-----Original Message-----
From: Charles Quesenberry [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 11:25 AM
To: Kirk Brannan Babb
Cc: [EMAIL PROTECTED]
Subject: Re: Problems starting MySQL as a Service for all users
Kirk,
I am somewhat confused by your question.
I must misunderstand what it is that you are trying to ask, because what
it
appears that you are asking makes no sense. Once MySQL was installed as
a
service, why does it matter which account starts it? Are you not the
admin
on the box? Are you trying to start multiple instances of the MySQL
service?
Logging off of the admin account will not stop a service on a Windows
2000
box. Even though you "log off the admin account", MySQL should still be
running.
Or, when you say "started" do you mean "connect to the running server"?
What is the output of the following command on the server running MySQL?
netstat -a -p tcp
Respectfully,
Charles Q.
At 08:23 PM 6/5/2002 -0500, you wrote:
>I've installed MySQL as a service using
>
> mysqld-nt --install
>
>on W2K. No problem there, says "service successfully installed". BUT,
>when I try to log off the admin account and on to the regular "power
>user" account MySQL will not start automagically and cannot be started
>manually. Pop back over to the admin account and MySQL acts like
>nothing was ever wrong.
>
>Is this an issue that can be overcome by manually installing MySQL as a
>service
>instead of using the above? And how do you accomplish that? If you know
or
>have heard of this before please help me out; I'd really like to have
MySQL
>running for all users (that would enable the Apache-based site I'm
running on
>the same box to access the database at all times).
>
>Thanks!
>
>Kirk
>
>
>
>
>---------------------------------------------------------------------
>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
