MySQL not working after reboot

Duncan Jones

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

Subscribe Post Reply

3299

Duncan Jones

"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

Duncan Jones

"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.

Jul 19 '05 #3

Aggro

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

Aggro

Duncan Jones wrote:

Any ideas based on that information???

Jul 19 '05 #5

Aggro

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

Duncan Jones

"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

Duncan Jones

"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

Duncan Jones

"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.

Jul 19 '05 #9

Aggro

Duncan Jones wrote:

Any ideas based on that information???

Jul 19 '05 #10

Duncan Jones

"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

bobb

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

bobb

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

Heikki Tuuri

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

Heikki Tuuri

"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

Alan Lane

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

Alan Lane

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

bobb

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

Aggro

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

Heikki Tuuri

"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

Aggro

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:

Jul 20 '05 #21

Alan Lane

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

Aggro

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:

Jul 20 '05 #23

by: miguel solórzano | last post by:

At 14:47 24/7/2003 +0200, Stefan Hinz wrote: Hi, > > (I think I messed up here. I decided to start from scratch, I removed > > "MySQL Servers and Clients 4.0.13" from the program list (as it...

MySQL Database

MySQL not working after reboot

by: Duncan Jones | last post by:

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...

MySQL Database

MySQL setup, Another twist - To mysqldump restoration ?

by: Adam Smith | last post by:

I have a dedicated server running 'FreeBSD 4.9 STABLE' at a hosting site. They have done some default installations, presumably from the CVS ports package ??. Herein lies the problem, "I do not...

MySQL Database

Closing MySQL Connections

by: Anthony | last post by:

Hey all, Here's a question for you, my hosts have told me that that one my pages, php, was causing their server to reboot because there were too many open connections and that they should be...

MySQL Database

Re-setting mysql as a service

by: wink martindale | last post by:

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 Database

MySQL stops functioning periodically - any ideas?

by: Richard | last post by:

Hi All, I've been trying to build a Ruby-on-Rails plus MySQL application. I'm running Ruby 1.8.2, Rails 1.1.4 and MySQL 5.0.15-nt over WinXP-Pro/SP2. I run under an Administrative account. ...

MySQL Database

110

MyISAM engine: worst case scenario in case of crash (mysql, O/S,hardware, whatever)

by: alf | last post by:

Hi, is it possible that due to OS crash or mysql itself crash or some e.g. SCSI failure to lose all the data stored in the table (let's say million of 1KB rows). In other words what is the worst...

MySQL Database

Will staying in php and mysql forever affect my future?

by: damod.php | last post by:

Iam a php/mysql developer. I wanna know whether staying in php and mysql forever would affect my future. Most s/w people are in either java or dotnet. Iam novice in both of them. I love php and i...

PHP

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

MySQL not working after reboot

Similar topics