Silly mysql+php install question
 

Is it possible to install PHP with mysql without needing to install the entire mysql server suite? I've seen lots of complaints about this in the past, just wondering if it's still a current issue.

Bit like installing a petrol station in your front yard when you only fill up once a week.

php is php and mysql is mysql, if anything you install php + mysql driver

Uh, what? The issue I'm talking about is that you have to install the whole mysql server in order to be able to use its client with PHP.

Are you installing it for Linux or Windows?

They have the installs pre-canned and should be the most current versions. Just do a Google search for LAMP (Linux) or WAMP (Windows). I would highly recommend going with LAMP. :2 cents:

If you're installing on your server then you can use localhost as your sql server instead of mysql.yourdomain.com as the database path.

If you want your page to vbe dynamic and you want to test it locally, you have no choice but to install the mysql server, and I bet that you do.

To be honest I haven't heard any complaints about it. =)

It's under FreeBSD, and the server is not local. That's the whole problem, I have to compile the entire server in order to install the client libraries for PHP to compile in.

It's not a biggie, just wondering if there's a more efficient way of doing it (ie just compiling the client library)

It depends on the distribution you are using. Most allow you to just install the client.

you just have to do a ./configure and add in mysql commands. most php install come with mysql already tied into it though. do a echo phpinfo(); and see if there is anything about mysql on it.

Which app dist do you mean? I'm using PHP 5.2.6, mysql 5.0.51b. Both compiled from source.

Sorry, meant distribution of linux. As for compiling from source, that's silly as most have package management systems that are pretty up to date.

I prefer to see what options I'm actually compiling in rather than see a bunch of configure stuff fly past too fast to read as it compiles what the maintainer has decided is best. :) It only takes about 5 minutes to compile mysql, php and apache from source.

Use that compile option:
--without-server Only build the client.

Aha! Thank you very much! Knew it had to be something simple. :pimp

you could always use the binary installer, pkg_add -r mysql5

You can install all of that in 1 executable. Look for the easy distros. SqlLite is easy to install and extremely small. Not sure how easy it is to get it to work in PHP though.

If you are manually compiling from source chances are you are doing something wrong to begin with.

The FreeBSD port sytem separates client and server:

/usr/ports/databases/mysql50-client
/usr/ports/databases/mysql50-server