mysql / php / dev on a mac?

PHP

OS X has apache built in, even on the client version. PHP is already there, waiting to be enabled via the Apache config file.

Just turn on Web Sharing and place your files in the /Library/Webserver/Documents folder and test them out in a browser.


I don't know of any mysql tools. I've only dabbled with it enough to create databases and tables and update them with calls from PHP.

You can get great info for all these topics over at http://www.oreillynet.com

heh.. dont you mean , , ::nudge::, ::nudge::

Originally posted by firewire2001
heh.. dont you mean , , ::nudge::, ::nudge::

Click to expand...

Well, since he actually says the words...I don't know...maybe.

I'm glad there are a few people out there who get the reference...especially someone in SoCal.

my linux friend helped me setup the php & mysql servers on OS X

he also helped me install a nice server called webmin... it looked relatively easy to do (just basically type install/setup in the terminal after unpackaging it)

webmin lets me edit the mysql databases & tables without having to type the sql manually; although the terminal can be just as nice

i'll look for links on setting up these servers tomorrow and post them up here if you guys are still interested

oh, by the way, i almost forgot to mention that of the OS's i've used within the last few months during the construction of a web site for a competition, mac os x was PERFECT for working with php & mysql

bbedit offers really nice code-highlighting and nifty find/replace features... also, when you double click near parentheses it will select the text between them (useful when look for missing (),{},[],etc)

i'm beginning to think that apple has transformed their os from one that couldn't edit code or serve worth a darn to the choice platform for both (bbedit & photoshop also put X over linux/windows for web design)

apple's really got one great package...

Originally posted by kishba
my linux friend helped me setup the php & mysql servers on OS X

he also helped me install a nice server called webmin... it looked relatively easy to do (just basically type install/setup in the terminal after unpackaging it)

webmin lets me edit the mysql databases & tables without having to type the sql manually; although the terminal can be just as nice

i'll look for links on setting up these servers tomorrow and post them up here if you guys are still interested

Click to expand...

I'll have to check out webmin, sounds interesting.

O'reilly has all the documentation I used for setting up PHP. It's simply a matter of uncommenting a couple of lines in the httpd.conf file for Apache.

And O'reilly is also nice enough to provide links to a double-clickable installer for mysql, as well as a patch to make it start on system start.

On a G4...absolutely!

I've even been able to do work on a G3 with OS X.

My TiBook has only a 400MHz G4, but that's plenty good for OS X. My one caveat is that if you're going to be using Classic as well, make sure you have plenty of RAM or else you'lll be paging out all day...not pretty.

Depends on the apps you'll be running.

I would say that 256 is a BARE minimum. 512 should be ample.

These articles should get you well on your way:
http://www.onlamp.com/pub/ct/49

I'm gonna go out on a limb here and say an emphatic NO.

mysql is an open-source, free database. MS is, well...MS.

You mean besides FileMaker...?

There's something to be said for that indeed.

It feels...purer, somehow.

i believe that macsql is an app for doing mysql db management in OS 9


you should also be able to run PHPmyAdmin on OS X for that mysql management, no?

Re: PHP

hee hee hee.....

wink, wink, nudge, nudge......

Monthy Python.... hee hee hee

Good one!

Originally posted by Choppaface
i believe that macsql is an app for doing mysql db management in OS 9


you should also be able to run PHPmyAdmin on OS X for that mysql management, no?

Click to expand...

I'm not familiar with PHPmyAdmin, and I looked on Versiontracker and didn't see it. Could you give us some more info?

I've never used it, but from what I read it's a very helpful tool....written in PHP so it shouldnt need to be ported to work on OS X

as always, google.com search for phpmyadmin reveals:

http://www.phpwizard.net/projects/phpMyAdmin/

as the home page for it


BTW, isn't mysql supposed to be installed as its own user (for security reasons)?

not that security is a big issue here because 1) we're mainly doing site dev not server dev and 2)we're privately testing
but I was wondering since I read it somewhere that it should have its own user.

also does anybody have a link to that 'double clickable' installer for mysql? I installed it a while ago to OS X and got lots of config warnings, but i never ran it so I never knew if it made a difference. i was wondering cuz this installer in question might have an OSX friendly config or something

my webhost has phpmyadmin installed on their server and it's very similar to webmin, except a little better in some aspects

either is nice for managing myself databases

try SQL4X Manager J

try SQL4X Manager J, a demo version is available from Apple's Download page.
http://www.apple.com/downloads/macosx/development_tools/sql4xmanagerj.html