Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Detailed article on Apache, PHP and mySQL UNIX
Webmonkey has posted an in-depth article covering Apache, PHP and mySQL on Mac OS X. It's written with a UNIX novice in mind, and walks you through the steps required to get each application running. It also includes an overview of Tenon's iTools.

A good read, and helpful if you're just getting started with this stuff.
  • Currently 4.33 / 5
  You rated: 5 / 5 (3 votes cast)

Detailed article on Apache, PHP and mySQL | 10 comments | Create New Account
Click here to return to the 'Detailed article on Apache, PHP and mySQL' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Little problem with the installation...
Authored by: tanhauser on Apr 20, '01 05:52:39PM

Hi folks...

I just upgraded Apache to the newest version (1.3.19) by following Scott Anguish's instructions over at stepwise:

The download went fine, the configuring went fine, making went fine, and making the install went fine.

So, after I installed it I went to System Preferences and into the 'Sharing' panel to restart it (was running), but now when I press start it just hangs on the 'Web Sharing Starting Up' message.

If I try to launch Apache trough the Terminal by typing:

% /usr/sbin/apachectl start

I get this:

Processing config directory: /private/etc/httpd/users
Processing config file: /private/etc/httpd/users/frank.conf
/usr/sbin/apachectl start: httpd could not be started

And throws me back to the prompt. Any ideas of what's going on?



[ Reply to This | # ]
Little problem with the installation...
Authored by: Anonymous on Apr 20, '01 10:27:42PM

I'm not sure what's causing the problem, but one thing you should look at is the apache error log, which
is stored in:


and see if that provides any hints.


[ Reply to This | # ]
Little problem with the installation...
Authored by: slord on May 29, '01 05:39:37PM

I have the exact same problem. I'm trying desperately to solve it, glad I'm not alone...

[ Reply to This | # ]
Your Dev Tools CD-ROM is pooched.
Authored by: Anonymous on May 30, '01 10:39:54AM

My was too. I managed to take down MySQL, PostgreSQL, php4.0.5, Apache, gawk, postfix on the way to discovering that.It was a very productive evening. I managed to trash my entire domain.

I bet if you an MD5 checksum on files you download and repeat the download & checksum process a few times you'll get different answers.

I got OS X the day it was shipped. I pooched my services almost immediately after. I called Apple tech support for a replacement. It still isn't here. I'm still waiting to repair the damage.

I'm a less than thrilled camper.

[ Reply to This | # ]
MySQL Access Denied
Authored by: hrair on May 05, '01 12:46:26AM
I think I'm banging my head on my desk too much and skipping some medication is not helping either but here's my problem:

I did as the article said and deleted the row from the user table:

delete from user where host='localhost' and user='';

but now I can't connect or do anything else. It is running. I can see it in the ps list. Here's what I get:

shell> mysql -u root test
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Is there a way I can uninstall MySQL and try again except this time i'll skipp the delete step.

[ Reply to This | # ]
MySQL Access Denied
Authored by: CodeOfficer on May 30, '01 01:22:59AM
What the hell, ... I'm having the same problem.

I wish macosxhints would try some of their suggestions out first before they get offered to the community. Perhaps removing some of the older "hints" that might be outdated would also be beneficial.


[ Reply to This | # ]
MySQL Access Denied
Authored by: theolein on Jun 03, '01 07:47:56PM

try typing :
..... ./mysql -u root -p [enter]
you should get a prompt for your root password that you *should* have given mysql when you installed it in the first place

[ Reply to This | # ]
MySQL Access Denied
Authored by: Kintaro on Oct 18, '01 01:49:47AM

I used the command to set the root password when I installed, and now no SQL database on MySQL can be accessed by PHP. They all return that they can't find the database that I just created, with no other error message. Not only that, but I had to include the login and password for my root account in my PHP document, which is bad. I made the mysql user on my system, but it doesn't have permission to access this database. This is all getting rather annoying with permissions.... if anyone has any help to offer, please do.


[ Reply to This | # ]
Authored by: pinqkandi on Jul 18, '02 12:24:14PM

Following the articles instructions, I get this error:

[localhost:~] mo% mysql -u root mysql
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I also get a bunch of password stuff with the earlier commands in the article - leaving it blank works fine though.

Any ideas?


[ Reply to This | # ]
Authored by: vincentm on Jan 06, '03 05:01:31PM


I already saw your problem elsewhere on the web....

**from the site posted below :
"Why do I get the message
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
when I try to connect to the DB using the "mysql" command line client?

Most likely you didn't start up the DB server. Try this:
cd /usr/local/mysql; sudo ./bin/safe_mysqld --user=mysql &
Then try to connect again.

Also note that if you downloaded and installed my StartupItem package for MySQL, you might have to download it again because it has been updated and now supports the new directory layout. The old one won't work anymore.

This is from :
Very good site anyway

[ Reply to This | # ]