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

re: MySQL not working after reboot

"Aggro" <spammerdream@yahoo.com> wrote in message
news:q7ddc.226$Vx4.37@read3.inet.fi...[color=blue]
> Duncan Jones wrote:
>[color=green]
> > I just installed MySQL 4.0.18 on my Win2K computer. Once it installed,[/color][/color]
I[color=blue][color=green]
> > ran the WinMySQLAdmin program and everything worked fine. The little[/color][/color]
green[color=blue][color=green]
> > light was on, and I could connect to my databases.[/color]
>
> Is the mysql server running? If not, start it.[/color]

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

re: MySQL not working after reboot

"Aggro" <spammerdream@yahoo.com> wrote in message
news:q7ddc.226$Vx4.37@read3.inet.fi...[color=blue]
> Duncan Jones wrote:
>[color=green]
> > I just installed MySQL 4.0.18 on my Win2K computer. Once it installed,[/color][/color]
I[color=blue][color=green]
> > ran the WinMySQLAdmin program and everything worked fine. The little[/color][/color]
green[color=blue][color=green]
> > light was on, and I could connect to my databases.[/color]
>
> Is the mysql server running? If not, start it.[/color]

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

re: MySQL not working after reboot

Duncan Jones wrote:
[color=blue]
> Any ideas based on that information???[/color]

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.

re: MySQL not working after reboot

Duncan Jones wrote:
[color=blue]
> Any ideas based on that information???[/color]

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.

re: MySQL not working after reboot

Duncan Jones wrote:
[color=blue]
> 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.[/color]

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

re: MySQL not working after reboot

"Aggro" <spammerdream@yahoo.com> wrote in message
news:Chgdc.304$Vx4.165@read3.inet.fi...[color=blue]
> Duncan Jones wrote:
>[color=green]
> > Any ideas based on that information???[/color]
>
> 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.[/color]

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

Grrrrrrr.

re: MySQL not working after reboot

"Aggro" <spammerdream@yahoo.com> wrote in message
news:Chgdc.304$Vx4.165@read3.inet.fi...[color=blue]
> Duncan Jones wrote:
>[color=green]
> > Any ideas based on that information???[/color]
>
> 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.[/color]

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

Grrrrrrr.

re: MySQL not working after reboot

"Aggro" <spammerdream@yahoo.com> wrote in message
news:q7ddc.226$Vx4.37@read3.inet.fi...[color=blue]
> Duncan Jones wrote:
>[color=green]
> > I just installed MySQL 4.0.18 on my Win2K computer. Once it installed,[/color][/color]
I[color=blue][color=green]
> > ran the WinMySQLAdmin program and everything worked fine. The little[/color][/color]
green[color=blue][color=green]
> > light was on, and I could connect to my databases.[/color]
>
> Is the mysql server running? If not, start it.[/color]

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

re: MySQL not working after reboot

Duncan Jones wrote:
[color=blue]
> Any ideas based on that information???[/color]

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.

re: MySQL not working after reboot

"Aggro" <spammerdream@yahoo.com> wrote in message
news:Chgdc.304$Vx4.165@read3.inet.fi...[color=blue]
> Duncan Jones wrote:
>[color=green]
> > Any ideas based on that information???[/color]
>
> 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.[/color]

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

Grrrrrrr.

re: MySQL not working after reboot

anything in the windows event log?

"Duncan Jones" <noemail@nospam.com> wrote in message
news:c5446c$4us$1@news7.svr.pol.co.uk...[color=blue]
>
> "Aggro" <spammerdream@yahoo.com> wrote in message
> news:Chgdc.304$Vx4.165@read3.inet.fi...[color=green]
> > Duncan Jones wrote:
> >[color=darkred]
> > > Any ideas based on that information???[/color]
> >
> > 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.[/color]
>
> I searched for an error file but found nothing relevant. I also tried[/color]
your[color=blue]
> "c:\mysql\bin\mysqld --standalone" thing, but no luck.
>
> Grrrrrrr.
>
>[/color]

re: MySQL not working after reboot

anything in the windows event log?

"Duncan Jones" <noemail@nospam.com> wrote in message
news:c5446c$4us$1@news7.svr.pol.co.uk...[color=blue]
>
> "Aggro" <spammerdream@yahoo.com> wrote in message
> news:Chgdc.304$Vx4.165@read3.inet.fi...[color=green]
> > Duncan Jones wrote:
> >[color=darkred]
> > > Any ideas based on that information???[/color]
> >
> > 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.[/color]
>
> I searched for an error file but found nothing relevant. I also tried[/color]
your[color=blue]
> "c:\mysql\bin\mysqld --standalone" thing, but no luck.
>
> Grrrrrrr.
>
>[/color]

re: MySQL not working after reboot

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" <noemail@nospam.com> kirjoitti viestissä
news:c542f4$hl8$1@newsg3.svr.pol.co.uk...[color=blue]
>
> "Aggro" <spammerdream@yahoo.com> wrote in message
> news:q7ddc.226$Vx4.37@read3.inet.fi...[color=green]
> > Duncan Jones wrote:
> >[color=darkred]
> > > I just installed MySQL 4.0.18 on my Win2K computer. Once it[/color][/color][/color]
installed,[color=blue]
> I[color=green][color=darkred]
> > > ran the WinMySQLAdmin program and everything worked fine. The little[/color][/color]
> green[color=green][color=darkred]
> > > light was on, and I could connect to my databases.[/color]
> >
> > Is the mysql server running? If not, start it.[/color]
>
> Therein lies the problem: the server always shuts itself down as soon as[/color]
I[color=blue]
> 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[/color]
"services"[color=blue]
> 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
>
>
>
>[/color]

re: MySQL not working after reboot

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" <noemail@nospam.com> kirjoitti viestissä
news:c542f4$hl8$1@newsg3.svr.pol.co.uk...[color=blue]
>
> "Aggro" <spammerdream@yahoo.com> wrote in message
> news:q7ddc.226$Vx4.37@read3.inet.fi...[color=green]
> > Duncan Jones wrote:
> >[color=darkred]
> > > I just installed MySQL 4.0.18 on my Win2K computer. Once it[/color][/color][/color]
installed,[color=blue]
> I[color=green][color=darkred]
> > > ran the WinMySQLAdmin program and everything worked fine. The little[/color][/color]
> green[color=green][color=darkred]
> > > light was on, and I could connect to my databases.[/color]
> >
> > Is the mysql server running? If not, start it.[/color]
>
> Therein lies the problem: the server always shuts itself down as soon as[/color]
I[color=blue]
> 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[/color]
"services"[color=blue]
> 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
>
>
>
>[/color]

re: MySQL not working after reboot

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" <noemail@nospam.com> wrote in message
news:c538dq$1qu$1@newsg4.svr.pol.co.uk...[color=blue]
> 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[/color]
green[color=blue]
> 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.[/color]
When[color=blue]
> 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
>
>[/color]

re: MySQL not working after reboot

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" <noemail@nospam.com> wrote in message
news:c538dq$1qu$1@newsg4.svr.pol.co.uk...[color=blue]
> 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[/color]
green[color=blue]
> 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.[/color]
When[color=blue]
> 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
>
>[/color]

re: MySQL not working after reboot

anything in the windows event log?

"Duncan Jones" <noemail@nospam.com> wrote in message
news:c5446c$4us$1@news7.svr.pol.co.uk...[color=blue]
>
> "Aggro" <spammerdream@yahoo.com> wrote in message
> news:Chgdc.304$Vx4.165@read3.inet.fi...[color=green]
> > Duncan Jones wrote:
> >[color=darkred]
> > > Any ideas based on that information???[/color]
> >
> > 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.[/color]
>
> I searched for an error file but found nothing relevant. I also tried[/color]
your[color=blue]
> "c:\mysql\bin\mysqld --standalone" thing, but no luck.
>
> Grrrrrrr.
>
>[/color]

re: MySQL not working after reboot

Alan Lane wrote:
[color=blue]
> for you. If not, you will need to install MySQL as a service in order for
> it to work correctly. Here's how:[/color]

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.

re: MySQL not working after reboot

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" <noemail@nospam.com> kirjoitti viestissä
news:c542f4$hl8$1@newsg3.svr.pol.co.uk...[color=blue]
>
> "Aggro" <spammerdream@yahoo.com> wrote in message
> news:q7ddc.226$Vx4.37@read3.inet.fi...[color=green]
> > Duncan Jones wrote:
> >[color=darkred]
> > > I just installed MySQL 4.0.18 on my Win2K computer. Once it[/color][/color][/color]
installed,[color=blue]
> I[color=green][color=darkred]
> > > ran the WinMySQLAdmin program and everything worked fine. The little[/color][/color]
> green[color=green][color=darkred]
> > > light was on, and I could connect to my databases.[/color]
> >
> > Is the mysql server running? If not, start it.[/color]
>
> Therein lies the problem: the server always shuts itself down as soon as[/color]
I[color=blue]
> 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[/color]
"services"[color=blue]
> 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
>
>
>
>[/color]

re: MySQL not working after reboot

Alan Lane wrote:
[color=blue]
> for you. If not, you will need to install MySQL as a service in order for
> it to work correctly. Here's how:[/color]

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.

re: MySQL not working after reboot

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" <noemail@nospam.com> wrote in message
news:c538dq$1qu$1@newsg4.svr.pol.co.uk...[color=blue]
> 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[/color]
green[color=blue]
> 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.[/color]
When[color=blue]
> 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
>
>[/color]

re: MySQL not working after reboot

Alan Lane wrote:
[color=blue]
> for you. If not, you will need to install MySQL as a service in order for
> it to work correctly. Here's how:[/color]

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.