Finishing this guide you'll get:
- A running WordPress installation
- Nginx proxy with PHP and Fast CGI
- MySQL server accessible with phpMyAdmin
Specification of latest running installation:
- Date: 03.03.2014
- OS: Ubuntu 64 bit - 12.04.4 LTS
- Provider: Amazon EC2
- Browser: Google Chrome - 33.0.1750.117
- WordPress: 3.8.1
- Nginx: 1.1.19
- MySQL: 5.5.35
- PHP: 5.3.10
- phpMyAdmin: 3.4.10.1
Requirements
- Server is behind a firewall, that only allows http, https and ssh
- The server is accessed with ssh keys (user password authentication must be disabled)
- Server is not accessed with the root user
- You're able to edit files with VI
Update Ubuntu
sudo apt-get update && sudo apt-get upgrade
Install additional packages
sudo aptitude install build-essential zip git
Install MySQL server and php5 MySQL module
sudo apt-get install mysql-server php5-mysql
Set the mysql root user password during the installation
Install the default MySQL databases
sudo mysql_install_db
Run the finisher script and respond every prompt with yes to get a secure MySQL installation
sudo /usr/bin/mysql_secure_installation
Connect to your new MySQL server
mysql -uroot -p
Enter the root password
And run this command to get the MySQL version
SHOW variables LIKE "%version%";
Install Nginx
sudo apt-get install nginx
Create a Nginx site configuration file
sudo touch /etc/nginx/sites-available/wordpress.conf
sudo vi /etc/nginx/sites-available/wordpress.conf
Paste this config
server {
listen 80;
root /var/www/wordpress;
index index.php index.html index.htm;
server_name [example.com];
location / {
try_files $uri $uri/ /index.php?q=$uri&$args;
}
error_page 404 /404.html;
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root /usr/share/nginx/www;
}
client_max_body_size 10M;
# pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
location ~ \.php$ {
try_files $uri = 404;
#fastcgi_pass 127.0.0.1:9000;
# With php5-fpm:
fastcgi_pass unix:/var/run/php5-fpm.sock;
fastcgi_index index.php;
include fastcgi_params;
}
}
Optionally you can rewrite false urls to a specified canonical url
server {
listen 80;
server_name www.example.com example.com;
if ($http_host = www.example.org) {
rewrite (.*) http://[example.com]$1;
}
...
}
Create a symlink to the config file
sudo ln -s /etc/nginx/sites-available/wordpress.conf /etc/nginx/sites-enabled/wordpress.conf
Restart Ngnix
sudo service nginx restart
Check Nginx version
nginx -v
Install PHP with FastCGI support
sudo apt-get install php5-fpm
configure PHP installaton
sudo vi /etc/php5/fpm/php.ini
Find the line cgi.fix_pathinfo=1 by pressing ESC and enter
/;cgi.fix_pathinfo=1
Uncomment this line and change value to 0
cgi.fix_pathinfo=0
If this number is kept as 1, the php interpreter will do its best to process the file that is as near to the requested file as possible. This is a possible security risk. If this number is set to 0, conversely, the interpreter will only process the exact file path—a much safer alternative.
Find the line ; default extension directory. and insert below
extension=mcrypt.so
Update the listening port for the php fpm
sudo vi /etc/php5/fpm/pool.d/www.conf
Set listen = /var/run/php5-fpm.sock
Restart the service
sudo service php5-fpm restart
Create the website folder
sudo mkdir /var/www/wordpress
Add a PHP info file
sudo vi /var/www/wordpress/info.php
Set content
<?php
phpinfo();
?>
Open your browser on http://example.com/info.php
Delete this file if everything works
Install phpMyAdmin
sudo apt-get install phpmyadmin
When phpMyAdmin prompts you to choose a server (either apache or lighttpd)hit tab, and select neither one.
When phpMyAdmin asks you wether to configure database for phpmyadmin with dbconfig-common. Chose and enter the MySQL root user password
Hit on the MySQL application password for phpmyadmin prompt.
Create a symbolic link for the phpMyAdmin website
sudo ln -s /usr/share/phpmyadmin/ /usr/share/nginx/www
Create a Nginx configuration file
sudo touch /etc/nginx/sites-available/phpmyadmin.conf
sudo vi /etc/nginx/sites-available/phpmyadmin.conf
Paste this config
server{
listen 80;
server_name [Your Public IP];
root /var/www/;
index index.php index.html index.htm;
client_max_body_size 10M;
location ~ .php$ {
try_files $uri = 404;
fastcgi_pass unix:/var/run/php5-fpm.sock;
fastcgi_index index.php;
include /etc/nginx/fastcgi_params;
}
}
Create a symlink to the config file
sudo ln -s /etc/nginx/sites-available/phpmyadmin.conf /etc/nginx/sites-enabled/phpmyadmin.conf
Restart Ngnix
sudo service nginx restart
Open the browser on http://[YourPublicIP]/phpmyadmin/
Open the WordPress site directory
cd /var/www/wordpress/
Download latest WordPress package and untar it
sudo wget http://wordpress.org/latest.tar.gz
tar -xzvf latest.tar.gz
Copy the untared files to the current folder and delete the other files
sudo cp -r ./wordpress/* ./
sudo rm -r wordpress
sudo rm latest.tar.gz
Let's create the MySQL WordPress user
mysql -u root -p
Enter the MySQL root user password
Create the WordPress database
CREATE DATABASE wordpress;
Create the WordPress database user
CREATE USER wordpress@localhost;
Set the password for the WordPress database user
SET PASSWORD FOR wordpress@localhost = PASSWORD("[password]");
Grant WordPress user full access on WordPress database
GRANT ALL PRIVILEGES ON wordpress.* TO wordpress@localhost IDENTIFIED BY '[password]';
Refresh MySQL and exit
FLUSH PRIVILEGES;
exit
Copy the WordPress example config file
sudo cp wp-config-sample.php wp-config.php
Edit the config file
sudo vi wp-config.php
Set database, database user and his password
define('DB_NAME', 'wordpress');
define('DB_USER', 'wordpress');
define('DB_PASSWORD', '[password]');
Update permissions for Nginx user
sudo chown www-data:www-data * -R
sudo usermod -a -G www-data www-data
Open the browser on http://example.com and install you WordPress blog
Install MySQL
How To Install Linux, nginx, MySQL, PHP (LEMP) stack on Ubuntu 12.04 by Digital Ocean
How To Install phpMyAdmin on a LEMP server by Digi
How To Install Wordpress with nginx on Ubuntu 12.04 by Digital Ocean
Nginx rewrite rules
Get MySQL version