List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:June 6 2002 6:25pm
Subject:Re: Problems starting MySQL as a Service for all users
View as plain text  
> FOR MY ADMIN ACCOUNT
> C:\>netstat -a -p tcp
>   TCP    dynamic:3306           dynamic:0              LISTENING
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> FOR THE REGULAR USER ACCOUNT
> C:\>netstat -a -p tcp

>   TCP    dynamic:3306           dynamic:0              LISTENING
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

The port is available under both accounts - the server is running.

> 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

I just proove you wrong...

> 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.


In your service manager (in the control panel), is the service listed there,
and is it started?  I personally, don't use the GUI mysqladmin utility.
mysql-nt --install installs the service, then I use service manager just
like I would for any other service (like IIS) on NT to be started.

When you're as a default non admin user account, did you ever try mysql to
connect to the server, or even better, telnet to port 3306 ?  If so, what
errors did you receive back from mysql or the telnet?  If you didn't maybe
it's time that you do.  I doubt this is a service related problem, but I may
be wrong... Using the right usernames / passwords / host addresses will also
help your cause when you have trouble connecting to the mysql server.



> -----Original Message-----
> From: Charles Quesenberry [mailto:charlesq@stripped]
> Sent: Thursday, June 06, 2002 11:25 AM
> To: Kirk Brannan Babb
> Cc: mysql@stripped
> 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 <mysql-thread111143@stripped>
> >To unsubscribe, e-mail
> ><mysql-unsubscribe-charlesq=dsl-only.net@stripped>
> >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 <mysql-thread111235@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-savage=savage.za.org@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
Problems starting MySQL as a Service for all usersKirk Brannan Babb6 Jun
  • Re: Problems starting MySQL as a Service for all usersCharles Quesenberry6 Jun
    • RE: Problems starting MySQL as a Service for all usersk6 Jun
      • Re: Problems starting MySQL as a Service for all usersChris Knipe6 Jun
      • RE: Problems starting MySQL as a Service for all usersCharles Quesenberry6 Jun