[HOWTO] - Setup PHP & MySQL

[DigiScript]

Man this is frustrating. I did something wrong when installing MySQL. I think I screwed up or skipped resetting the root password. Now I can not create databases. I can play with the "test" database all I want, but that ain't gonna cut it.
This is what it says to do to reset the password:

./bin/mysqladmin -u root -p password 'new_password'
./bin/mysqladmin -u root -h localhost -p password 'new_password'

But that does nothing. I have re-installed multiple times and still no luck. I am familiar with using PHP and mySQL, but have never done ANYTHING with Unix before, so I am pretty lost.

Side note: It still has 'mysql user deleted' folders in my Users' folder from the users I deleted in my attempt to figure out this mess. It wont let me get rid of them. Any help on this would be greatly appreciated.

If someone, anyone can help me get all this figured out I will be your bestest friend for ever and ever.

Thanks,
Digi

[yoshi]

hey j00, if resetting your mysql password failed then you have no password for root is should be blank.. if you want to reset your password try this from the terminal its what I used to set my password:

/usr/local/mysql/bin/mysqladmin password new-password

type the directory exactly as I did only change new-password to the password you want!

This should work if you followed the directions above!

~Yoshi

[laron8]

ok the php install isnt working. Someone please help me. I am about to copy and past everything it says.
Welcome to Darwin!
[localhost:~] nate% curl -O http://www2.entropy.ch/download/libphp4.so.gz
% Total % Received % Xferd Average Speed Time Curr.
Dload Upload Total Current Left Speed
100 4723k 100 4723k 0 0 20165 0 0:03:59 0:03:59 0:00:00 14145
[localhost:~] nate% gunzip libphp4.so.gz
[localhost:~] nate% sudo mv libphp4.so /usr/libexec/httpd/
Password:
[localhost:~] nate% cd /etc/httpd
[localhost:/etc/httpd] nate% sudo apxs -e -a -n php4 libexec/httpd/libphp4.so
[activating module `php4' in /private/etc/httpd/httpd.conf]
cp /private/etc/httpd/httpd.conf /private/etc/httpd/httpd.conf.bak
cp /private/etc/httpd/httpd.conf.new /private/etc/httpd/httpd.conf
rm /private/etc/httpd/httpd.conf.new
[localhost:/etc/httpd] nate% sudo perl -p -i.bak -e 's%#(AddType \S+-php[ -])%$
Unmatched '.
[localhost:/etc/httpd] nate% sudo perl -p -i.bak -e 's%#(AddType \S+-php[ -])%$1%i' httpd.conf
[localhost:/etc/httpd] nate% sudo apachectl graceful
/usr/sbin/apachectl graceful: httpd not running, trying to start
Syntax error on line 240 of /etc/httpd/httpd.conf:
Cannot load /usr/libexec/httpd/libphp.so into server: (reason unknown)
/usr/sbin/apachectl graceful: httpd could not be started
[localhost:/etc/httpd] nate%


See I did everything right. and also my mysql install aint work either...here is what I got.


Welcome to Darwin!
[localhost:~] nate% cd /usr/local/mysql
/usr/local/mysql: No such file or directory.
[localhost:~] nate% cd /usr/local/mysql
/usr/local/mysql: No such file or directory.
[localhost:~] nate% cd /usr/local/mysql
/usr/local/mysql: No such file or directory.
[localhost:~] nate% cd /usr/local/MySQL
/usr/local/MySQL: No such file or directory.
[localhost:~] nate% cd /usr/local/mysql
/usr/local/mysql: No such file or directory.
[localhost:~] nate%


Whats up? This is starting to get on my nerves. Please help.

[yoshi]

See I did everything right. and also my mysql install aint work either...here is what I got.


Welcome to Darwin!
[localhost:~] nate% cd /usr/local/mysql
/usr/local/mysql: No such file or directory.
[localhost:~] nate% cd /usr/local/mysql
/usr/local/mysql: No such file or directory.
[localhost:~] nate% cd /usr/local/mysql
/usr/local/mysql: No such file or directory.
[localhost:~] nate% cd /usr/local/MySQL
/usr/local/MySQL: No such file or directory.
[localhost:~] nate% cd /usr/local/mysql
/usr/local/mysql: No such file or directory.
[localhost:~] nate%

Are you sure you did that MySQL Install right? because I don't see the transcript there and you can't just /usr/local/mysql and hope its there, you have to download and follow the directions.

Now as for your PHP problem you DID NOT follow my directions and here is what you did wrong, you did this:
cp /private/etc/httpd/httpd.conf /private/etc/httpd/httpd.conf.bak
cp /private/etc/httpd/httpd.conf.new /private/etc/httpd/httpd.conf
rm /private/etc/httpd/httpd.conf.new

That screwed up your apache config and I did not specify any commands like those. All you needed to do to add the php config lines to the httpd.conf was this:
[localhost:/etc/httpd] nate% sudo perl -p -i.bak -e 's%#(AddType \S+-php[ -])%$1%i' httpd.conf

Now I have no clue what httpd.conf has in it since you replaced it but look at line 240 for your problem.


Sincerely
~Yoshi

[laron8]

ok..I have no idea what your talking about. I copied and pasted every last thing you said to make sure i didnt type it wrong. When I copied ans psated sudo apxs -e -a -n php4 libexec/httpd/libphp4.so this stuff below came up on its own.

[activating module `php4' in /private/etc/httpd/httpd.conf]
cp /private/etc/httpd/httpd.conf /private/etc/httpd/httpd.conf.bak
cp /private/etc/httpd/httpd.conf.new /private/etc/httpd/httpd.conf
rm /private/etc/httpd/httpd.conf.new

it gave me another prompt and I copied and pasted
sudo perl -p -i.bak -e 's%#(AddType \S+-php[ -])%$1%i' httpd.conf
so I dont see where i went wrong.
and with the mysql..yea I forgot to install it..my bad...but when I do..where do I install it to? Can you give me a command on that?

I am very very very new to this. I been looking for tutorials on this stuff...but I found yours and it seemed easy enough. lol I followed step by step..and still somehow mess up.

[yoshi]

what version of OS X are you using?
10.1.2
10.1.1
10.1
10.0.x

lemme know

[laron8]

10.1.2 hey im me on aim at ree122

[yoshi]

Okay after half an hour on your computer via SSH I have got Apache + php working .

After step 7 a unique step for you is required since the apache server was complaining about not being able to find libphp.so which is and should be named libphp4.so I just simply typed this:
sudo mv /usr/libexec/httpd/libphp4.so /usr/libexec/httpd/libphp.so

to fix the problem. After that you could go to step 8 normally. I reccomend anyone else having the same php + apache problem to try that. Now everything should be working. I will do mysql if you wish as well..

Cheers

~Yoshi