List:General Discussion« Previous MessageNext Message »
From:Charles Quesenberry Date:June 6 2002 6:40pm
Subject:RE: Problems starting MySQL as a Service for all users
View as plain text  
Okay, I think I understand now.

If you notice, tcp port 3306 is "listening" when you are logged in as both 
the administrator and as a "regular user".  Port 3306 is the MySQL 
server/daemon.

Your problem isn't with the MySQL server.  Your MySQL server is started and 
waiting on connections.

Your problem is with "connecting" to the server.  This is an entire 
different issue, which is constantly asked on this list.  Your problem is 
with the permissions you have set for MySQL.  We can discuss this more, and 
I will tell you how to fix it, but first I have a question.

I am not familiar with this "winmysqladmin manager" program.  But, I 
suggest that you take it out of the startup for all users and leave it in 
the startup for only the admin user.

Can you try that, then restart the entire system (Win2K), and tell me if 
you are still experiencing problems?

I suspect that you really don't have any problems at all, other than the 
one you created by putting the "winmysqladmin manager" program in startup 
for all users.  It has fooled you into believing that your MySQL server 
wasn't running.



Respectfully,
Charles Q.



At 01:08 PM 6/6/2002 -0500, you wrote:
>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: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-charlesq=dsl-only.net@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