Howto nginx + php5 + mysql + phpmyadmin + ubuntu shortest setup

The following tutorial is done with Ubuntu Lucid 10.04 on Lenovo Thinkpad X200 laptop. In this tutorial, I will show you the shortest and easiest way to set up nginx up with PHP5, MySQL and phpmyadmin running through FastCGI.

UPDATE: I am going to do another post on nginx installation, but this time with PHP-FM instead of spawn-fcgi, this new piece of software has gained attention recently. Stay tuned guys!

Install all softwares:

sudo apt-get install nginx mysql-server-5.1 php5-cgi php5-mysql phpmyadmin

Make sure you set up the MySQL root password.

Create php-fastcgi init script:

sudo nano /etc/init.d/php-fastcgi

Inside, paste the following code into it:

#!/bin/bash
BIND=127.0.0.1:9000
USER=www-data
PHP_FCGI_CHILDREN=15
PHP_FCGI_MAX_REQUESTS=1000

PHP_CGI=/usr/bin/php-cgi
PHP_CGI_NAME=`basename $PHP_CGI`
PHP_CGI_ARGS="- USER=$USER PATH=/usr/bin PHP_FCGI_CHILDREN=$PHP_FCGI_CHILDREN PHP_FCGI_MAX_REQUESTS=$PHP_FCGI_MAX_REQUESTS $PHP_CGI -b $BIND"
RETVAL=0

start() {
      echo -n "Starting PHP FastCGI: "
      start-stop-daemon --quiet --start --background --chuid "$USER" --exec /usr/bin/env -- $PHP_CGI_ARGS
      RETVAL=$?
      echo "$PHP_CGI_NAME."
}
stop() {
      echo -n "Stopping PHP FastCGI: "
      killall -q -w -u $USER $PHP_CGI
      RETVAL=$?
      echo "$PHP_CGI_NAME."
}

case "$1" in
    start)
      start
  ;;
    stop)
      stop
  ;;
    restart)
      stop
      start
  ;;
    *)
      echo "Usage: php-fastcgi {start|stop|restart}"
      exit 1
  ;;
esac
exit $RETVAL

Next we make the script executable and make it auto-startup by default.

sudo chmod +x /etc/init.d/php-fastcgi
sudo service php-fastcgi start
sudo update-rc.d php-fastcgi defaults

Create virtual host file for phpmyadmin

sudo nano /etc/nginx/sites-available/phpmyadmin

The content is

server{
	listen 80;
	server_name phpmyadmin;
	access_log /var/log/phpmyadmin.access_log;
	error_log /var/log/phpmyadmin.error_log;

	location / {
	  root /usr/share/phpmyadmin;
	  index index.php;
	}

	location ~ \.php$ {
	    fastcgi_pass    127.0.0.1:9000;
	    fastcgi_index   index.php;
	    fastcgi_param   SCRIPT_FILENAME /usr/share/phpmyadmin$fastcgi_script_name;
	    include         fastcgi_params;
	}
}

Now we need to enable this vhost

sudo ln -s /etc/nginx/sites-available/phpmyadmin /etc/nginx/sites-enabled/phpmyadmin

sudo nano /etc/hosts

Append the ‘phpmyadmin’ into 127.0.0.1 line

127.0.0.1	localhost phpmyadmin

Now restart the nginx server

sudo service nginx start

Fire up your Firefox and type in http://phpmyadmin. Enjoy!

About Jones Lee

Nothing much about me..

View all posts by Jones Lee →