mySQL stopped working.

[Impassible]

Hi, I am having some real trouble. I don't know anything about troubleshooting mySQL, I'm really new to this. Let me start off by letting you know what I'm running:

I have a Mac Blue/white G3 350, running OSX 10.3.4 (panther). I am connected to the net on a wireless DSL network. mySQL version 4.0.18.

I am building a website on my computer, and testing it locally. (I am using a PHP CMS called Expression Engine [http://www.expressionengine.com])

Normally, if I put my website in the /Library/WebServer/Documents directory (on my computer), if I go http://127.0.0.1 I could connect to myself and see the website. If I wanted OTHER people to be able to access it, I would have to configure the router to have all incoming connections point to MY computer (because its a network and it needs to forward the other people the info to get to THIS computer). Then I could use a custom address from http://www.dyndns.org and other people could use that to connect to me. I had tried this before, and it worked.

But NOW, after I switched all incoming connections to my computer, and tried it. I was unable to connect to even myself at 127.0.0.1.. it would start to load the page, but stall about one fourth of the way loaded... and it would never continue. I decided I should restart my computer because that might fix the problem, but upon startup, I tried to connect to my database and it said connection refused.... my website won't display because it can't connect to my databse. So, I thought --- Hey it worked before, I just changed one thing (the router settings), I'll change it back and I should be okay.

I changed it back, but mySQL is still inaccessible (even at 127.0.0.1) .... and now I don't know what to do.. I don't understand WHY this didnt' work, because I had done it before.... Ive tried using YourSQL (program to access/manage database) but that wont connect either...

Please help!
thanks,

[Xnuiem]

Unfortunely, for all that text, and we didnt even give a basic overview of the actual issue.

You have already noticed it is a MySQL issue. Is MySQL running? That would be the first and formost question...

[Impassible]

Sorry but Im really not sure whats going on. I am new to mySQL. Ive installed it a few months ago, and have used it normally until now.

I don't know if its running or not... I would think not because when I try to connect to it I get an error. I had it set up when I first installed it a long time ago, to automatically start up during boot, so I wouldn't have to manually do it each time, or something.
I have tried to start it manually:

 sudo /usr/local/mysql/bin/mysqld_safe --user=mysql &

---- the command I use to manually start it up (from the instructions I have)

When I try that it says this:

172:~ HiDDuKeL$ Starting mysqld daemon with databases from /usr/local/mysql/data
040630 06:40:01 mysqld ended

Then it sits there, if I press a key, this shows up:

 [2]+ Done          sudo /usr/local/mysql/bin/mysqld_safe --user=mysql

This is all I know: I use a program called YourSQL to connect/manage my database. I put in my settings (login/password... IP [127.0.0.1], localhost) and I'd press connect, it would connect and I could manage my stuff. But now, I get Connection Refused when trying. I hope that helps clear something up... if not let me know what else I can provide you. I'm not really sure what to look for and what not.

Thanks

[Impassible]

Sory havent had much sleep. :P

I just checked my processes, no its not running, as I suspected.

so have you fixed it, if i was you, i;d use phpadmin, its far better, cuz u have more ocntrol over your databases, just create a php cod eot connect to the server with the correct passwords, then include the php file in all your code so it connects.