Configuring mysql on freebsd server

[sc_king]

Hi,

I just purchased a new dedicated server. I installed apache and php and those are working. I don't have mysql working with those yet though.
Mysql seems to have been installed since i can get in from the root.

I don't see any extensions of mysql though, just the mysqld and mysql.
I have tried installing php with --with-mysql=/path also but that always fails on me.

Is there anyway of adding in the extensions after installation?

I really need help.

Thanks

[chazzy]

no - php needs to be compiled with it.

i think you need to compile php with the mysql source code, not the binaries.

[svidgen]

Did you downloaded the appropriate headers and libraries before attempting to reinstall/reconfigure PHP? ( http://us3.php.net/manual/en/mysql.installation.php ) Sun seems to have slightly reorganized the MySQL site since I've been there--so I can't point you in the direction of the specific download you need (unless it's coincidentally the same one I used).

I think the following lines from my root history are relevant:

$ wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-devel-5.1.26-0.glibc23.i386.rpm/from/http://mirror.services.wisc.edu/mysql/
$ rpm -i MySQL-devel-5.1.26-0.glibc23.i386.rpm

... And then the PHP configure command line option I needed was '--with-mysql=/usr/include/mysql/'.

I realize some of that will likely be specific to CentOS, but perhaps it helps anyway ...