Silly mysql+php install question - GoFuckYourself.com

rowan · 05-28-2008, 06:07 AM

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.

mike-al · 05-28-2008, 07:09 AM

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

rowan · 05-28-2008, 08:47 AM

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.

TripleXPrint · 05-28-2008, 09:43 AM

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.

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.

chelo - adultcopywriters · 05-28-2008, 09:49 AM

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. =)

rowan · 05-28-2008, 09:49 AM

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)

mrkris · 05-28-2008, 09:52 AM

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

CS-Jay · 05-28-2008, 09:56 AM

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.

rowan · 05-28-2008, 09:58 AM

Quote:

Originally Posted by mrkris

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

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

mrkris · 05-28-2008, 10:01 AM

Quote:

Originally Posted by rowan

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.

rowan · 05-28-2008, 10:11 AM

Quote:

Originally Posted by mrkris

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.

onezero · 05-28-2008, 10:14 AM

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

rowan · 05-28-2008, 10:20 AM

Quote:

Originally Posted by onezero

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

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

Vicious Adult · 05-28-2008, 11:30 AM

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

brandonstills · 05-28-2008, 02:29 PM

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.

react · 05-28-2008, 07:26 PM

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

05-28-2008, 06:07 AM	#1
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	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.

05-28-2008, 07:09 AM	#2
mike-al Confirmed User Join Date: Aug 2007 Posts: 691	php is php and mysql is mysql, if anything you install php + mysql driver __________________ Delete this account, i am done here

05-28-2008, 09:43 AM	#4
TripleXPrint Confirmed User Join Date: Apr 2007 Posts: 983	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. 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. __________________ Skype: Triplexprint

05-28-2008, 09:49 AM	#5
chelo - adultcopywriters Confirmed User Join Date: Feb 2008 Location: Montevideo Posts: 775	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. =) Last edited by chelo - adultcopywriters; 05-28-2008 at 09:50 AM..

05-28-2008, 09:52 AM	#7
mrkris Confirmed User Join Date: May 2005 Posts: 2,737	It depends on the distribution you are using. Most allow you to just install the client. __________________ PHP-MySQL-Rails \| ICQ: 342500546

05-28-2008, 08:47 AM	#3
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	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.

05-28-2008, 09:56 AM	#8
CS-Jay Confirmed User Join Date: Oct 2003 Location: Command Central, West Palm Beach, Fl Posts: 1,794	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. __________________ I do stuff - aIm CS_Jay_D

05-28-2008, 10:14 AM	#12
onezero Registered User Join Date: Oct 2007 Posts: 40	Use that compile option: --without-server Only build the client. __________________ OneZero Hosting - We're a perfect 10 when it comes to your hosting and Internet needs! To us every last customer and every server also rates a perfect ten! IM (xmpp): [email protected], http://onezerohosting.com, [email protected]

05-28-2008, 11:30 AM	#14
Vicious Adult Registered User Join Date: Dec 2007 Posts: 9	you could always use the binary installer, pkg_add -r mysql5

05-28-2008, 02:29 PM	#15
brandonstills Confirmed User Join Date: Dec 2007 Location: Chatsworth, CA Posts: 1,964	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. __________________ Brandon Stills Industry and programming veteran [email protected] \| skype: brandonstills \| ICQ #495-171-318

05-28-2008, 07:26 PM	#16
react Confirmed User Industry Role: Join Date: Sep 2003 Location: NZ Posts: 673	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 __________________ -- react Last edited by react; 05-28-2008 at 07:27 PM..