[HOWTO] - Setup PHP & MySQL

[yoshi]

Okay I have offically setup a Mirror to get the mysql package:

You can download it here:
http://www.machowto.com/mysql-3.32.47.pkg.tar

Sorry about that folks~

[d-mac-d]

thanks for the quick reply. Everything's running smooth now. thanks.

- dm

[d-mac-d]

Thanks for the great help on mysql. It works fantastically!

Now, php is not working. I have done all of the steps exactly, and it appears that apache is configured (at least partially) because I get this in the error_log when I do a graceful restart:

[Mon Mar 11 11:31:10 2002] [notice] Apache/1.3.22 (Darwin) PHP/4.1.2 configured -- resuming normal operations

I am trying to test it with a document called test.php containing:

<?php phpinfo() ?>

help!

- dm

[yoshi]

Use this script

################
#Php Information Page #
################
<?php
phpinfo();
?>


~Yoshi

[Nitro]

I had the same problem a lisamac, and this solved the problem for me..
I just ran steps 6 and 7 again after I rebooted, and I could access my databases.

Type "cd /usr/local/mysql"
type "sudo chown -R mysql /usr/local/mysql/*"
type "sudo ./bin/safe_mysqld --user=mysql &"

then type "mysql test"

to use the database test in mysql.

I just hope I don't have to run this every time I reboot, anyone know how to have it automaticaly initiate at startup?

-Eric

[jkestr]

Nevermind

[rmdxx]

i've been able to install mysql and query the sever. however, i seem to be unable to shut it down or make any password changes. i get the "access denied for user: '@localhost'.

i've checked the manual included with the distribution and the web and am stuck. when i tried to set a password for the root account using
"mysqladmin password" it told me i was "using mysql as an anonymous users and anonymous users are not allowed to change passwords"

any help would be greatly appreciated.

thanks!

[yoshi]

Come to irc and we can help you as this requires a lot of typing

~Yoshi