469,929 Members | 1,569 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

MySQL not working after reboot

Hello,

I just installed MySQL 4.0.18 on my Win2K computer. Once it installed, I
ran the WinMySQLAdmin program and everything worked fine. The little green
light was on, and I could connect to my databases.

However, as soon as I restarted my computer, the green light changed to a
red light, and since then I've been unable to connect to my databases. When
I open WinMySQLAdmin, the "Server" group box on the Environment page is
completely empty (it used to have lots of server information in it).

How can I remedy this situation??

Thanks in advance,

Duncan Jones
Jul 19 '05 #1
22 3092

"Aggro" <sp**********@yahoo.com> wrote in message
news:q7**************@read3.inet.fi...
Duncan Jones wrote:
I just installed MySQL 4.0.18 on my Win2K computer. Once it installed, I ran the WinMySQLAdmin program and everything worked fine. The little green light was on, and I could connect to my databases.


Is the mysql server running? If not, start it.


Therein lies the problem: the server always shuts itself down as soon as I
start it.

The following is a list of what I attempted just now when I booted up:

~~~~~~~~~~~~~~~

Windows boots up ......... WinMySQLAdmin starts up and minimises to
tray...

Green light..... (3 seconds)..... red light :-(

Open up "Services" from "Administrative Tools" and manual restart the
server...... "Server started succesfully"..
..... brief green light....... light goes red again. Reopen the "services"
thing, and the MySQL service is no longer running.

Try running the mysqld-nt.exe file. No effect.

Then open up a command prompt. Type "net start mysql"......... "service
started successfully".....
.... brief green light again........... red after ~3 seconds.

As a test, I type "net stop mysql"....... sure enough....... "cannot stop
service as it is not running etc."

~~~~~~~~~~~~~~~~~~~

Any ideas based on that information???

Duncan Jones


Jul 19 '05 #2

"Aggro" <sp**********@yahoo.com> wrote in message
news:q7**************@read3.inet.fi...
Duncan Jones wrote:
I just installed MySQL 4.0.18 on my Win2K computer. Once it installed, I ran the WinMySQLAdmin program and everything worked fine. The little green light was on, and I could connect to my databases.


Is the mysql server running? If not, start it.


Therein lies the problem: the server always shuts itself down as soon as I
start it.

The following is a list of what I attempted just now when I booted up:

~~~~~~~~~~~~~~~

Windows boots up ......... WinMySQLAdmin starts up and minimises to
tray...

Green light..... (3 seconds)..... red light :-(

Open up "Services" from "Administrative Tools" and manual restart the
server...... "Server started succesfully"..
..... brief green light....... light goes red again. Reopen the "services"
thing, and the MySQL service is no longer running.

Try running the mysqld-nt.exe file. No effect.

Then open up a command prompt. Type "net start mysql"......... "service
started successfully".....
.... brief green light again........... red after ~3 seconds.

As a test, I type "net stop mysql"....... sure enough....... "cannot stop
service as it is not running etc."

~~~~~~~~~~~~~~~~~~~

Any ideas based on that information???

Duncan Jones


Jul 19 '05 #3
Duncan Jones wrote:
Any ideas based on that information???


I have only used mysql as standalone, i.e. I start it with command:
c:\mysql\bin\mysqld --standalone

So I don't know about services or anything else you mentioned about. How
ever there should be error.log on your computer, which might tell why it
does that.
Jul 19 '05 #4
Duncan Jones wrote:
Any ideas based on that information???


I have only used mysql as standalone, i.e. I start it with command:
c:\mysql\bin\mysqld --standalone

So I don't know about services or anything else you mentioned about. How
ever there should be error.log on your computer, which might tell why it
does that.
Jul 19 '05 #5
Duncan Jones wrote:
I just installed MySQL 4.0.18 on my Win2K computer. Once it installed, I
ran the WinMySQLAdmin program and everything worked fine. The little green
light was on, and I could connect to my databases.


Is the mysql server running? If not, start it.
Jul 19 '05 #6

"Aggro" <sp**********@yahoo.com> wrote in message
news:Ch***************@read3.inet.fi...
Duncan Jones wrote:
Any ideas based on that information???


I have only used mysql as standalone, i.e. I start it with command:
c:\mysql\bin\mysqld --standalone

So I don't know about services or anything else you mentioned about. How
ever there should be error.log on your computer, which might tell why it
does that.


I searched for an error file but found nothing relevant. I also tried your
"c:\mysql\bin\mysqld --standalone" thing, but no luck.

Grrrrrrr.
Jul 19 '05 #7

"Aggro" <sp**********@yahoo.com> wrote in message
news:Ch***************@read3.inet.fi...
Duncan Jones wrote:
Any ideas based on that information???


I have only used mysql as standalone, i.e. I start it with command:
c:\mysql\bin\mysqld --standalone

So I don't know about services or anything else you mentioned about. How
ever there should be error.log on your computer, which might tell why it
does that.


I searched for an error file but found nothing relevant. I also tried your
"c:\mysql\bin\mysqld --standalone" thing, but no luck.

Grrrrrrr.
Jul 19 '05 #8

"Aggro" <sp**********@yahoo.com> wrote in message
news:q7**************@read3.inet.fi...
Duncan Jones wrote:
I just installed MySQL 4.0.18 on my Win2K computer. Once it installed, I ran the WinMySQLAdmin program and everything worked fine. The little green light was on, and I could connect to my databases.


Is the mysql server running? If not, start it.


Therein lies the problem: the server always shuts itself down as soon as I
start it.

The following is a list of what I attempted just now when I booted up:

~~~~~~~~~~~~~~~

Windows boots up ......... WinMySQLAdmin starts up and minimises to
tray...

Green light..... (3 seconds)..... red light :-(

Open up "Services" from "Administrative Tools" and manual restart the
server...... "Server started succesfully"..
..... brief green light....... light goes red again. Reopen the "services"
thing, and the MySQL service is no longer running.

Try running the mysqld-nt.exe file. No effect.

Then open up a command prompt. Type "net start mysql"......... "service
started successfully".....
.... brief green light again........... red after ~3 seconds.

As a test, I type "net stop mysql"....... sure enough....... "cannot stop
service as it is not running etc."

~~~~~~~~~~~~~~~~~~~

Any ideas based on that information???

Duncan Jones


Jul 19 '05 #9
Duncan Jones wrote:
Any ideas based on that information???


I have only used mysql as standalone, i.e. I start it with command:
c:\mysql\bin\mysqld --standalone

So I don't know about services or anything else you mentioned about. How
ever there should be error.log on your computer, which might tell why it
does that.
Jul 19 '05 #10

"Aggro" <sp**********@yahoo.com> wrote in message
news:Ch***************@read3.inet.fi...
Duncan Jones wrote:
Any ideas based on that information???


I have only used mysql as standalone, i.e. I start it with command:
c:\mysql\bin\mysqld --standalone

So I don't know about services or anything else you mentioned about. How
ever there should be error.log on your computer, which might tell why it
does that.


I searched for an error file but found nothing relevant. I also tried your
"c:\mysql\bin\mysqld --standalone" thing, but no luck.

Grrrrrrr.
Jul 19 '05 #11
anything in the windows event log?

"Duncan Jones" <no*****@nospam.com> wrote in message
news:c5**********@news7.svr.pol.co.uk...

"Aggro" <sp**********@yahoo.com> wrote in message
news:Ch***************@read3.inet.fi...
Duncan Jones wrote:
Any ideas based on that information???
I have only used mysql as standalone, i.e. I start it with command:
c:\mysql\bin\mysqld --standalone

So I don't know about services or anything else you mentioned about. How
ever there should be error.log on your computer, which might tell why it
does that.


I searched for an error file but found nothing relevant. I also tried

your "c:\mysql\bin\mysqld --standalone" thing, but no luck.

Grrrrrrr.

Jul 20 '05 #12
anything in the windows event log?

"Duncan Jones" <no*****@nospam.com> wrote in message
news:c5**********@news7.svr.pol.co.uk...

"Aggro" <sp**********@yahoo.com> wrote in message
news:Ch***************@read3.inet.fi...
Duncan Jones wrote:
Any ideas based on that information???
I have only used mysql as standalone, i.e. I start it with command:
c:\mysql\bin\mysqld --standalone

So I don't know about services or anything else you mentioned about. How
ever there should be error.log on your computer, which might tell why it
does that.


I searched for an error file but found nothing relevant. I also tried

your "c:\mysql\bin\mysqld --standalone" thing, but no luck.

Grrrrrrr.

Jul 20 '05 #13
Hi!

Try running mysqld from an MS-DOS prompt:

mysqld --console

What does it print?

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php

Register now for the 2004 MySQL Users Conference!
http://www.mysql.com/events/uc2004/index.html

"Duncan Jones" <no*****@nospam.com> kirjoitti viestissä
news:c5**********@newsg3.svr.pol.co.uk...

"Aggro" <sp**********@yahoo.com> wrote in message
news:q7**************@read3.inet.fi...
Duncan Jones wrote:
I just installed MySQL 4.0.18 on my Win2K computer. Once it
installed,
I ran the WinMySQLAdmin program and everything worked fine. The little green light was on, and I could connect to my databases.
Is the mysql server running? If not, start it.


Therein lies the problem: the server always shuts itself down as soon as

I start it.

The following is a list of what I attempted just now when I booted up:

~~~~~~~~~~~~~~~

Windows boots up ......... WinMySQLAdmin starts up and minimises to
tray...

Green light..... (3 seconds)..... red light :-(

Open up "Services" from "Administrative Tools" and manual restart the
server...... "Server started succesfully"..
.... brief green light....... light goes red again. Reopen the "services" thing, and the MySQL service is no longer running.

Try running the mysqld-nt.exe file. No effect.

Then open up a command prompt. Type "net start mysql"......... "service
started successfully".....
... brief green light again........... red after ~3 seconds.

As a test, I type "net stop mysql"....... sure enough....... "cannot stop
service as it is not running etc."

~~~~~~~~~~~~~~~~~~~

Any ideas based on that information???

Duncan Jones

Jul 20 '05 #14
Hi!

Try running mysqld from an MS-DOS prompt:

mysqld --console

What does it print?

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php

Register now for the 2004 MySQL Users Conference!
http://www.mysql.com/events/uc2004/index.html

"Duncan Jones" <no*****@nospam.com> kirjoitti viestissä
news:c5**********@newsg3.svr.pol.co.uk...

"Aggro" <sp**********@yahoo.com> wrote in message
news:q7**************@read3.inet.fi...
Duncan Jones wrote:
I just installed MySQL 4.0.18 on my Win2K computer. Once it
installed,
I ran the WinMySQLAdmin program and everything worked fine. The little green light was on, and I could connect to my databases.
Is the mysql server running? If not, start it.


Therein lies the problem: the server always shuts itself down as soon as

I start it.

The following is a list of what I attempted just now when I booted up:

~~~~~~~~~~~~~~~

Windows boots up ......... WinMySQLAdmin starts up and minimises to
tray...

Green light..... (3 seconds)..... red light :-(

Open up "Services" from "Administrative Tools" and manual restart the
server...... "Server started succesfully"..
.... brief green light....... light goes red again. Reopen the "services" thing, and the MySQL service is no longer running.

Try running the mysqld-nt.exe file. No effect.

Then open up a command prompt. Type "net start mysql"......... "service
started successfully".....
... brief green light again........... red after ~3 seconds.

As a test, I type "net stop mysql"....... sure enough....... "cannot stop
service as it is not running etc."

~~~~~~~~~~~~~~~~~~~

Any ideas based on that information???

Duncan Jones

Jul 20 '05 #15
Hi Duncan:

I had a similar problem with MySQL on Win2K Pro. I now have MySQL up and
running just fine. Here are some thoughts from my experience:

Press Ctrl-Alt-Delete, then "Task Manager", then click "Processes". Do you
see mysql listed as one of the running processes? If so, I have no answers
for you. If not, you will need to install MySQL as a service in order for
it to work correctly. Here's how:

Open up a DOS window (Start-Run-"Cmd"). Change directories to where your
MySQL binaries are (C:\mysql\bin, for instance). Type in
"mysqld-nt --install" and then press Enter. It should say that it has
loaded as a service. Close the DOS window, and then re-boot your machine.
Now, when you check in Task Manager again, can you see mysql running as a
Process? If so, good. WinMySQLAdmin should now work for you. Good luck!

Alan

"Duncan Jones" <no*****@nospam.com> wrote in message
news:c5**********@newsg4.svr.pol.co.uk...
Hello,

I just installed MySQL 4.0.18 on my Win2K computer. Once it installed, I
ran the WinMySQLAdmin program and everything worked fine. The little green light was on, and I could connect to my databases.

However, as soon as I restarted my computer, the green light changed to a
red light, and since then I've been unable to connect to my databases. When I open WinMySQLAdmin, the "Server" group box on the Environment page is
completely empty (it used to have lots of server information in it).

How can I remedy this situation??

Thanks in advance,

Duncan Jones

Jul 20 '05 #16
Hi Duncan:

I had a similar problem with MySQL on Win2K Pro. I now have MySQL up and
running just fine. Here are some thoughts from my experience:

Press Ctrl-Alt-Delete, then "Task Manager", then click "Processes". Do you
see mysql listed as one of the running processes? If so, I have no answers
for you. If not, you will need to install MySQL as a service in order for
it to work correctly. Here's how:

Open up a DOS window (Start-Run-"Cmd"). Change directories to where your
MySQL binaries are (C:\mysql\bin, for instance). Type in
"mysqld-nt --install" and then press Enter. It should say that it has
loaded as a service. Close the DOS window, and then re-boot your machine.
Now, when you check in Task Manager again, can you see mysql running as a
Process? If so, good. WinMySQLAdmin should now work for you. Good luck!

Alan

"Duncan Jones" <no*****@nospam.com> wrote in message
news:c5**********@newsg4.svr.pol.co.uk...
Hello,

I just installed MySQL 4.0.18 on my Win2K computer. Once it installed, I
ran the WinMySQLAdmin program and everything worked fine. The little green light was on, and I could connect to my databases.

However, as soon as I restarted my computer, the green light changed to a
red light, and since then I've been unable to connect to my databases. When I open WinMySQLAdmin, the "Server" group box on the Environment page is
completely empty (it used to have lots of server information in it).

How can I remedy this situation??

Thanks in advance,

Duncan Jones

Jul 20 '05 #17
anything in the windows event log?

"Duncan Jones" <no*****@nospam.com> wrote in message
news:c5**********@news7.svr.pol.co.uk...

"Aggro" <sp**********@yahoo.com> wrote in message
news:Ch***************@read3.inet.fi...
Duncan Jones wrote:
Any ideas based on that information???
I have only used mysql as standalone, i.e. I start it with command:
c:\mysql\bin\mysqld --standalone

So I don't know about services or anything else you mentioned about. How
ever there should be error.log on your computer, which might tell why it
does that.


I searched for an error file but found nothing relevant. I also tried

your "c:\mysql\bin\mysqld --standalone" thing, but no luck.

Grrrrrrr.

Jul 20 '05 #18
Alan Lane wrote:
for you. If not, you will need to install MySQL as a service in order for
it to work correctly. Here's how:


I have myself installed MySQL to many computers, almost all succesfully
(*, and never as service. So it is possible to get it to work as a
standalone also.

(* One time I needed to fight a little to get it to work. There was some
firewall on that computer and I answer "don't allow" to it's question
whether to allow MySQL to listen ports or not. So it didn't work after
that. It helped when I set parameter to allow and restarted the
firewall. ( It took few minutes to figure out I needed to restart it. )
But in this case, the mysqld process could be seen in the task manager.
Jul 20 '05 #19
Hi!

Try running mysqld from an MS-DOS prompt:

mysqld --console

What does it print?

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php

Register now for the 2004 MySQL Users Conference!
http://www.mysql.com/events/uc2004/index.html

"Duncan Jones" <no*****@nospam.com> kirjoitti viestissä
news:c5**********@newsg3.svr.pol.co.uk...

"Aggro" <sp**********@yahoo.com> wrote in message
news:q7**************@read3.inet.fi...
Duncan Jones wrote:
I just installed MySQL 4.0.18 on my Win2K computer. Once it
installed,
I ran the WinMySQLAdmin program and everything worked fine. The little green light was on, and I could connect to my databases.
Is the mysql server running? If not, start it.


Therein lies the problem: the server always shuts itself down as soon as

I start it.

The following is a list of what I attempted just now when I booted up:

~~~~~~~~~~~~~~~

Windows boots up ......... WinMySQLAdmin starts up and minimises to
tray...

Green light..... (3 seconds)..... red light :-(

Open up "Services" from "Administrative Tools" and manual restart the
server...... "Server started succesfully"..
.... brief green light....... light goes red again. Reopen the "services" thing, and the MySQL service is no longer running.

Try running the mysqld-nt.exe file. No effect.

Then open up a command prompt. Type "net start mysql"......... "service
started successfully".....
... brief green light again........... red after ~3 seconds.

As a test, I type "net stop mysql"....... sure enough....... "cannot stop
service as it is not running etc."

~~~~~~~~~~~~~~~~~~~

Any ideas based on that information???

Duncan Jones

Jul 20 '05 #20
Alan Lane wrote:
for you. If not, you will need to install MySQL as a service in order for
it to work correctly. Here's how:


I have myself installed MySQL to many computers, almost all succesfully
(*, and never as service. So it is possible to get it to work as a
standalone also.

(* One time I needed to fight a little to get it to work. There was some
firewall on that computer and I answer "don't allow" to it's question
whether to allow MySQL to listen ports or not. So it didn't work after
that. It helped when I set parameter to allow and restarted the
firewall. ( It took few minutes to figure out I needed to restart it. )
But in this case, the mysqld process could be seen in the task manager.
Jul 20 '05 #21
Hi Duncan:

I had a similar problem with MySQL on Win2K Pro. I now have MySQL up and
running just fine. Here are some thoughts from my experience:

Press Ctrl-Alt-Delete, then "Task Manager", then click "Processes". Do you
see mysql listed as one of the running processes? If so, I have no answers
for you. If not, you will need to install MySQL as a service in order for
it to work correctly. Here's how:

Open up a DOS window (Start-Run-"Cmd"). Change directories to where your
MySQL binaries are (C:\mysql\bin, for instance). Type in
"mysqld-nt --install" and then press Enter. It should say that it has
loaded as a service. Close the DOS window, and then re-boot your machine.
Now, when you check in Task Manager again, can you see mysql running as a
Process? If so, good. WinMySQLAdmin should now work for you. Good luck!

Alan

"Duncan Jones" <no*****@nospam.com> wrote in message
news:c5**********@newsg4.svr.pol.co.uk...
Hello,

I just installed MySQL 4.0.18 on my Win2K computer. Once it installed, I
ran the WinMySQLAdmin program and everything worked fine. The little green light was on, and I could connect to my databases.

However, as soon as I restarted my computer, the green light changed to a
red light, and since then I've been unable to connect to my databases. When I open WinMySQLAdmin, the "Server" group box on the Environment page is
completely empty (it used to have lots of server information in it).

How can I remedy this situation??

Thanks in advance,

Duncan Jones

Jul 20 '05 #22
Alan Lane wrote:
for you. If not, you will need to install MySQL as a service in order for
it to work correctly. Here's how:


I have myself installed MySQL to many computers, almost all succesfully
(*, and never as service. So it is possible to get it to work as a
standalone also.

(* One time I needed to fight a little to get it to work. There was some
firewall on that computer and I answer "don't allow" to it's question
whether to allow MySQL to listen ports or not. So it didn't work after
that. It helped when I set parameter to allow and restarted the
firewall. ( It took few minutes to figure out I needed to restart it. )
But in this case, the mysqld process could be seen in the task manager.
Jul 20 '05 #23

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by miguel solórzano | last post: by
2 posts views Thread by Duncan Jones | last post: by
3 posts views Thread by Anthony | last post: by
4 posts views Thread by wink martindale | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.