{"id":3229,"date":"2014-04-25T08:45:12","date_gmt":"2014-04-25T08:45:12","guid":{"rendered":"http:\/\/ubuntuhandbook.org\/?p=3229"},"modified":"2014-04-25T08:45:12","modified_gmt":"2014-04-25T08:45:12","slug":"install-nginx-with-php5-mysql-lemp-in-ubuntu-14-04-server","status":"publish","type":"post","link":"https:\/\/ubuntuhandbook.org\/index.php\/2014\/04\/install-nginx-with-php5-mysql-lemp-in-ubuntu-14-04-server\/","title":{"rendered":"Install Nginx with Php5 & Mysql (LEMP) in Ubuntu 14.04 Server"},"content":{"rendered":"

\"LEMP<\/a><\/p>\n

Want to build a website on your Ubuntu Server? Well, LEMP may be a good choice and here’s how to install and set it up.<\/p>\n

LEMP<\/b> stands for Linux<\/b>, Nginx<\/b> (pronounced \u201cengine x\u201d), MySQL<\/b> and PHP<\/b>. The nginx project started with a strong focus on high concurrency, high performance and low memory usage. So it\u2019s a good alternative to Apache webserver for building websites on low memory hosts.<\/p>\n

To get started<\/b>, log in your Ubuntu Server and follow the steps below:<\/p>\n

1. Install MySQL<\/b><\/p>\n

MySQL is a database management system which stores and organizes references to the information the webserver needs.<\/p>\n

To install Mysql 5.5.36, run command:<\/p>\n

sudo apt-get install mysql-server mysql-client<\/pre>\n
To install Mysql 5.6.16, run:<\/p>\n
sudo apt-get install mysql-server-5.6 mysql-client-5.6<\/pre>\n
While the installing process, you’ll be asked to type a password for MySQL root user.<\/p>\n
2. Install Nginx<\/b><\/p>\n
Nginx 1.4.6 is available in Ubuntu repositories. To install it, run:<\/p>\n
sudo apt-get install nginx<\/pre>\n
If you want, install the latest stable Nginx 1.4.7 from PPA:<\/p>\n
sudo apt-get install python-software-properties\n\nsudo add-apt-repository ppa:nginx\/stable\n\nsudo apt-get update\n\nsudo apt-get install nginx<\/pre>\n
Once installed, start the web service via:<\/p>\n
sudo service nginx start<\/pre>\n
And check out if it is working by going to http:\/\/serverip<\/em><\/span><\/p>\n
\"nginx<\/a>
nginx is working ubuntu 14.04<\/p><\/div>\n
3. Install PHP5<\/b><\/p>\n
PHP<\/b> is a reflective programming language, which makes it possible for all these different parts to work together.<\/p>\n
We can make PHP5 work in nginx through PHP-FPM, which is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busier sites.<\/p>\n
Run command below to install php5-fpm:<\/p>\n
sudo apt-get install php5-fpm<\/pre>\n
4. Setup Nginx<\/b><\/p>\n
The nginx configuration files are available in \/etc\/nginx\/nginx.conf<\/i>, read this configuration example<\/a>.<\/p>\n
To modify the default site example:<\/p>\n
sudo vi \/etc\/nginx\/sites-available\/default<\/pre>\n
Here you can define the root directory (to put WordPress files there), your site domain name, as well as other settings. See the example below:<\/p>\n
server {\n\tlisten 80 default_server;\n\tlisten [::]:80 default_server ipv6only=on;\n\n\troot \/usr\/share\/nginx\/html<\/b>;\n\tindex index.php index.html index.htm;\n\n\t# Make site accessible from http:\/\/localhost\/\n\tserver_name localhost<\/b>;\n\n\tlocation \/ {\n\n\t\ttry_files $uri $uri\/ \/index.php;\n\n\t}\n\n\tlocation \/doc\/ {\n\t\talias \/usr\/share\/doc\/;\n\t\tautoindex on;\n\t\tallow 127.0.0.1;\n\t\tallow ::1;\n\t\tdeny all;\n\t}\n\n\t#\n\terror_page 500 502 503 504 \/50x.html;\n\tlocation = \/50x.html {\n\t\troot \/usr\/share\/nginx\/html;\n\t}\n\n\tlocation ~ \\.php$ {\n\n\t\t# With php5-fpm:\n                try_files $uri =404;\n\t\tfastcgi_pass unix:\/var\/run\/php5-fpm.sock;\n\t\tfastcgi_index index.php;\n\t\tinclude fastcgi_params;\n\t}\n\n\t# deny access to .htaccess files, if Apache's document root\n\t# concurs with nginx's one\n\t#\n\tlocation ~ \/\\.ht {\n\t\tdeny all;\n\t}\n}<\/pre>\n
Remember to restart the web service to apply changes:<\/p>\n
sudo service nginx reload<\/pre>\n
5. Check if PHP is working<\/b><\/p>\n
Create the test file:<\/p>\n
sudo vi \/usr\/share\/nginx\/html\/info.php<\/pre>\n
Add following lines and save the file:<\/p>\n
<?php\nphpinfo();\n?><\/pre>\n
Go to http:\/\/serverip\/info.php<\/em><\/span> in client’s web browser and you\u2019ll see:<\/p>\n
\"php<\/a>
php is working<\/p><\/div>\n
6 Get MySQL working with PHP:<\/b> Install Xcache (list of PHP accelerators<\/a>), a free and open PHP opcode cacher for caching and optimizing PHP intermediate code, as well as other PHP modules:<\/p>\n
sudo apt-get install php5-mysql php5-curl php5-gd php5-intl php-pear php5-imagick php5-imap php5-mcrypt php5-memcache php5-ming php5-ps php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl php5-xcache<\/pre>\n
Then restart php5:<\/p>\n
sudo service php5-fpm restart<\/pre>\n
Now reload http:\/\/serverip\/info.php<\/em><\/span> page and scroll down to find out if there\u2019s a section about MySQL:<\/p>\n
\"mysql<\/a>
mysql is working with php<\/p><\/div>\n
For security reason, remove the info.php after the test:<\/p>\n
sudo rm \/usr\/share\/nginx\/html\/info.php<\/pre>\n
7. Install Phpmyadmin to manage Mysql Database via web:<\/b><\/p>\n
First install phpmyadmin:<\/p>\n
sudo apt-get install phpmyadmin<\/pre>\n
During the installation, it will ask you if you want to configure the database with dbconfig. Go ahead and choose yes.<\/p>\n
Input MySQL\u2019s database password when prompted and click ok.<\/p>\n
When phpmyadmin prompts you to choose a server (either apache or lighttpd) hit tab, and select neither one.<\/p>\n
Second, create a symbolic link between phpMyAdmin and your site’s directory:<\/p>\n
sudo ln -s \/usr\/share\/phpmyadmin\/ \/usr\/share\/nginx\/html<\/pre>\n
Restart nginx and finally you’re able to access phpmyadmin by going to http:\/\/serverip\/phpmyadmin<\/em><\/span> and typing Mysql username and password.<\/p>\n
sudo service nginx restart<\/pre>\n
Done!<\/p>","protected":false},"excerpt":{"rendered":"
Want to build a website on your Ubuntu Server? Well, LEMP may be a good choice and here’s how to install and set it up. LEMP stands for Linux, Nginx (pronounced \u201cengine x\u201d), MySQL and PHP. The nginx project started with a strong focus on high concurrency, high performance and low memory usage. So it\u2019s […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,1],"tags":[747,748,855,1059],"class_list":["post-3229","post","type-post","status-publish","format-standard","hentry","category-howtos","category-ubuntu-server-2","tag-lemp","tag-nginx","tag-ubuntu-14-04","tag-web-server"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/posts\/3229","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/comments?post=3229"}],"version-history":[{"count":0,"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/posts\/3229\/revisions"}],"wp:attachment":[{"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/media?parent=3229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/categories?post=3229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/tags?post=3229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}