Problems with mySQL Can someone help. PLEASE

webbersdreams · - Joined: 02 Nov 2003 Posts: 3

OK Here's the problem I bring up mysql and it stays green for about 5 seconds then turn red. :( I have no idea what is going on I installed it how it said I even tried unistalling it and reinstalling it. I thought maybe it was my zone alarm but i tried running it with zone alarm off and still nothing. I am running Windows Xp Pro with Abyss web server my seb server works fine but I can't get my mysql database server to conect for the life of me. please can some one tell me how to fix this. Thanks in advance.

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

You would need to read my tutorial to get a more visual
image of how MySQL is installed but sadly enough , I tried
installing linux on my PC and screwed up and now im waiting
on my Recory kit that HP is sending me to rebuild my winXP and
HP PC Recovery drive so now I have to wait until Mon or Tue to get
my web server back up and running , my website for the tutorials is

http://os17fan.cjb.net "Should be up on Mon or Tue"

iNaNimAtE · Posted: Fri Mar 12, 2004 2:03 am Post subject:

Well, I had the same problem a couple days ago.

My forums were dead for a week or two; due to the same problem you describe. I also run XP Pro. However, I fixed my problem by doing the following:

1) Right click on the MySQL icon in the taskbar (the street light).
2) Go to "Win NT>Stop the service" and hit OK to the prompt that comes up.
3) Go into your task manager, and under the "Services" tab, look for "mysqld-nt.exe" and hit "End Process."
4) Right click the MySQL icon again, and this time, hit "Remove the Service."
5) Once you have done all of that, uninstall MySQL.
6) Go back to the MySQL website and download a fresh copy of their newest stable version.
7) Go ahead and install it.

Although it may seem a little redundent, that is exactly what worked for me. Hopefully, it will fix your problem also.
_________________
Bienvenidos!

webbersdreams · - Joined: 02 Nov 2003 Posts: 3

I just got the install the day before yesterday. So it is the latest stable version.

iNaNimAtE · Posted: Sat Mar 13, 2004 4:31 am Post subject:

And after following my directions, it still didn't work?
_________________
Bienvenidos!

Lawrence · - Joined: 16 Jan 2003 Posts: 207 Location: Brisbane, AU

The MySQL documentation is very thorough, and includes many references to error logs which will tell you exactly why the system isn't booting up properly. The five seconds of green you experience aren't five seconds of happy normal runtime, that's how long it takes to set the light green, run through the initialization, and fail to actually start.

I had similar problems and solved them by setting MySQL to run in debug mode, and going through the log one error at a time. Eventually I had to reinstall it and pay more attention to which deamon it was trying to run, what passwords were in use, etc.

Still not sure why it just up and died one day, but checking your error logs will definitely help you solve the mystery.

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

Just to let you know , my recovery kit came in
a little early so now my website is back up !

Abyss Web Server: Tutorials
http://os17fan.cjb.net

webbersdreams · - Joined: 02 Nov 2003 Posts: 3

Grrrr. Nothing I try is working. I am about to give up this is so frustrating. But it's not for something like a forum where I can find somethink else to run it. Its for my Business my shopping carts are reliant on IT IS the ONLY things i can use. this really sucks. The manual for mysql is nothing but way to long and I don't have the time to go through 1200 pages to find a few blerps about how to fix it. Grrrrr.