> 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:[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 > > --------------------------------------------------------------------- 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