470,588 Members | 2,103 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,588 developers. It's quick & easy.

Re-setting mysql as a service

Hello,

I installed mysql server 4.1 last month. When I installed it, I set it
to run as a service to start automatically. However, for some reason,
that no longer occurs. I can't even see the mysql service running from
services viewer in win xp. I now have to manually start mysql server
each time I reboot.
Can someone please tell me how I can Re-set mysql to run as a
service?? Or, if I re-install mysql, will it retain the db's already
created??

TIA,

Wink
Sep 28 '05 #1
4 1450
wink martindale wrote:
Can someone please tell me how I can Re-set mysql to run as a
service??
It's probably most straightforward and safest to reinstall MySQL. You
could hand-edit the registry to recreate the service entry, but that is
neither quicker nor more likely to succeed.
Or, if I re-install mysql, will it retain the db's already
created??


It "should" retain the databases, or any other files that aren't part of
the default install. But it's always a good idea to back up your
databases before doing something like changing the DBMS software.

Remember: computers are out to get you. Not users in general, but YOU.
It's personal. ;-)

Regards,
Bill K.
Sep 28 '05 #2
On Wed, 28 Sep 2005 08:45:14 -0500, in mailing.database.mysql wink
martindale <wi**@martindale.com> wrote:
| Hello,
|
| I installed mysql server 4.1 last month. When I installed it, I set it
| to run as a service to start automatically. However, for some reason,
| that no longer occurs. I can't even see the mysql service running from
| services viewer in win xp. I now have to manually start mysql server
| each time I reboot.
| Can someone please tell me how I can Re-set mysql to run as a
| service?? Or, if I re-install mysql, will it retain the db's already
| created??


Reboot your machine so you can see the default properties.

Right mouse click the My Computer icon. Select Manage from the popup
menu.
The mmc window will open. Select Service and Applications.
Click Services. The right panel will list all the services that are
available to your machine.
Scroll to the MySQL entry.
My entry reads as:
mySQL Started, Automatic, Local system
Double click mySQL to bring up the properties box.
Set the StartType to Automatic, click the Start button.

Have a look at the MySqlAdmin icon in the systray. Is it green?
If it is then your up and running, if not then there could be an error
in you my.ini file.
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------
Sep 28 '05 #3

"wink martindale" <wi**@martindale.com> wrote in message
news:rd********************************@4ax.com...
Hello,

I installed mysql server 4.1 last month. When I installed it, I set it
to run as a service to start automatically. However, for some reason,
that no longer occurs. I can't even see the mysql service running from
services viewer in win xp. I now have to manually start mysql server
each time I reboot.
Can someone please tell me how I can Re-set mysql to run as a
service?? Or, if I re-install mysql, will it retain the db's already
created??

TIA,

Wink

Oct 7 '05 #4
try Start>Control Pannel>Administrative Tools>Component Services

This should bring up a list of services which you can reset to run at
startup etc.

Let me know if this works.
Larry
"wink martindale" <wi**@martindale.com> wrote in message
news:rd********************************@4ax.com...
Hello,

I installed mysql server 4.1 last month. When I installed it, I set it
to run as a service to start automatically. However, for some reason,
that no longer occurs. I can't even see the mysql service running from
services viewer in win xp. I now have to manually start mysql server
each time I reboot.
Can someone please tell me how I can Re-set mysql to run as a
service?? Or, if I re-install mysql, will it retain the db's already
created??

TIA,

Wink

Oct 7 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Nel | last post: by
4 posts views Thread by Craig Bailey | last post: by
1 post views Thread by Chris | last post: by
11 posts views Thread by James | last post: by
1 post views Thread by John Ryan | last post: by
10 posts views Thread by James | last post: by
2 posts views Thread by sky2070 | last post: by
1 post views Thread by Brian | last post: by
1 post views Thread by Clarice Almeida Hughes | last post: by
2 posts views Thread by JW | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.