FreeBSD

Install openssl

pkg install openssl

Install MySQL server

pkg search mysql
pkg install mysql55-server-5.5.37 → server 5.5 doesn’t have the hangups that 5.6 does for nedi

Setup root mysql user password, enable root for my host

> mysql -u root
> UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
> GRANT ALL PRIVILEGES ON *.* TO 'root'@'remote host' IDENTIFIED BY 'MyNewPass' WITH GRANT OPTION;
> CREATE USER ‘nedi’@'localhost' IDENTIFIED BY PASSWORD 'MyNewPass';
> GRANT ALL PRIVILEGES ON nedi.* TO ‘nedi’@'localhost';
> FLUSH PRIVILEGES;

Then as root or sudo’d run the below command. This will remove the anonymous user and allow remote access on the freebsd install. more info here http://www.xfiles.dk/guide-on-how-to-install-mysql-on-freebsd/
> mysql_secure_installation

Then create database “nedi” on the server from MySQL workbench

Install Apache Server

pkg search apache
pkg install apache24-2.4.9_2

Configure apache
nano /usr/local/etc /apache24/httpd .conf → add directives in alias section “”

Alias /nedi /usr/local/www/nedi/html

Require all granted

Install PHP

cd to directory with php files currently using 5.4.28
./configure –with-apxs2 –with-mysql → builds php with mysql and apache modules.

make
make install

2014 by Eric Browning