[HOWTO] - Setup PHP & MySQL

[lcwid]

I used my brain and got it to work. But I'm still looking for a good book or two to help.

[lisamac]

<snip>ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) </snip>

k. I'm really trying to use my brain too - but my hair is falling out... can you provide some insight on how you solved this problem? I'd love to know - really :-D

Thanks in advance -
LisaMac

[yoshi]

okay that means mysqld isn't running . This tells me one of two things, one you didn't do the install right and the dameon isn't running right or at all or two you didn't do the below step and mysql isn't running .

try this:
Step 1) CD to the mysql install directory
Step 2) type "sudo ./bin/safe_mysqld --user=mysql &"

that should start mysql and allow you to do the test

Hope this helps

`Yoshi

[lisamac]

[localhost:/usr/local/mysql] lisamac% sudo ./bin/safe_mysqld --user=mysql &
[1] 428
[localhost:/usr/local/mysql] lisamac% Password:******
******: Command not found.
[localhost:/usr/local/mysql] lisamac%

is what i get when I try to run the above command (password is not all stars , but i tend to reuse my passwords for things like discussion forums, so i put them in instead of my password)- when i type in my password i get the command not found error...... i suck, i know... please help!

btw, thanks for getting back to me so fast :-D You're a lifesaver!

Cheers,
LisaMac

[lisamac]

I downloaded the nice installation app from Marc Liyanage and installed as requested. did the steps maticulously ( i think ). I know that i've installed wrong though, cause I knew enough to try to start it. I think I understand the process... i got the error message "sorry the host 'blah blah' could not be looked up. Please configure the host command... etc etc." so i realized that my network guys had applied a hostname to me when i plugged in. Thinking i'm going to be working offline most of the time anyway i unplugged the network connection and restarted... this took me out to [localhost] so i tried to run mySQL again... now i'm getting the socket error.

I'm sure this makes no sense... i still suck... thanks for those who might try to decipher this though...

should i uninstall mysql and try again? if so, which files do i get rid of? or is there a simple way to actually re-configure the host command?

Thanks again m8's,
cheers,
LisaMac

[yoshi]

[localhost:/usr/local/mysql] lisamac% sudo ./bin/safe_mysqld --user=mysql &
[1] 428
[localhost:/usr/local/mysql] lisamac% Password:******
******: Command not found.
[localhost:/usr/local/mysql] lisamac%


Okay thats something with the sudo command, it might give you that error if you enter you password wrong, at this point I would try redoing all the steps from #1 and see if it duplicates the error, get back with me

`Yoshi

[lisamac]

Seems I just needed to sleep on it... thanks so much for your help yoshi - I ran the process from the beginning, just like you said and it worked!

I now have mySql and PHP running! :-D I'm so happy!

Thanks,
LisaMac

[yoshi]

Your very welcome . If you do need any more help please don't hesitate to ask.

~Yoshi