Configuration of nginx + php + mysql in ubuntu _ PHP

This article introduces how to configure nginx + php + mysq in ubuntu, 1. Update

Www.bitsCN.com

The code is as follows:

Sudo apt-get update

2. install nginx

The code is as follows:

Sudo apt-get intsall nginx

After Ubuntu is installed, the file structure is roughly as follows:

* All configuration files are under/etc/nginx, and each virtual host has been arranged under/etc/nginx/sites-available www.bitsCN.com.

* The program file is stored in the/usr/sbin/nginx * log in/var/log/nginx.

* The startup script nginx has been created under/etc/init. d /.

* The default virtual host directory is/var/www/nginx-default.

You can start nginx to see the effect (make sure there are no other services in use on port 80 ):

The code is as follows:

Sudo/etc/init. d/nginx start

# Or simply

The code is as follows:

Service nginx start

Open the browser and check http: // localhost/to see if "Welcome to nginx!" is displayed !" If yes, the installation is successful.

Of course, basically, there is no problem with this Part. if it fails to run, you can first

The code is as follows:

Sudo killall apache2

Kill apache process

3. install php

The code is as follows:

Sudo apt-get install php5 php5-cgi php5-mysql php5-curl php5-gd php5-idn php5-imagick php5-imap php5-mcrypt php5-memcache php5-mhash php5-ming php5-pspell php5-recode

4. install spawn-fcgi

Why is spawn-fcgi installed? it is used to control the php-cgi process to prevent process crashes or the efficiency of a single process is too low.

Many people on the Internet say that to use spawn-fcgi, lighttpd must be installed. In fact, it is not necessary to install spawn-fcgi directly.

Run:

The code is as follows:

Sudo apt-get install spawn-fcgi

5. configuration

The next step is the most frustrating configuration.

Configure Nginx and spawn-fcgi to run together

(1) add a line at the end of the/etc/nginx/fastcgi_params file. you can use

sudo vi /etc/nginx/fastcgi_params 

Join this line:

fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

(2). In addition, you need to find the cgi. fix_pathinfo option in the configuration file of the PHP-CGI (which is located in/etc/php5/cgi/php. ini on Ubuntu) and change it:

cgi.fix_pathinfo=1;

In this way, the SCRIPT_FILENAME variable can be used normally in php-cgi.

(3) open the/etc/nginx/sites-available/default file in

server {listen 80;server_name localhost;

Add the absolute address of the web root directory below. here the default address of nginx is used.

root /var/www/nginx-default

That is, the root and server_name are at the same level, which is equivalent to the default directory of apache.

If this is not available, it is easy to prompt"No input file specified".

I found the problem only after a large circle. then I modified it.

# Location ~ . Php $ {
# Fastcgi_pass 127.0.0.1: 9000;
# Fastcgi_index index. php;
# Fastcgi_param SCRIPT_FILENAME/scripts $ fastcgi_script_name;
# Define defastcgi_params;
#}

Modify

Location ~ . Php $ {
Fastcgi_pass 127.0.0.1: 9000;
Fastcgi_index index. php;
Fastcgi_param SCRIPT_FILENAME/var/www/nginx-default $ fastcgi_script_name;
Include/etc/nginx/fastcgi_params; # address of the parameter file containing fastcgi

6. start the fast_cgi process.

sudo /usr/bin/spawn-fcgi -a 127.0.0.1 -p 9000 -C 5 -u www-data -g www-data -f /usr/bin/php5-cgi -P /var/run/fastcgi-php.pid

7. set boot to start fastcgi process and start

sudo vi /etc/rc.local

Add next line

/usr/bin/spawn-fcgi -a 127.0.0.1 -p 9000 -C 5 -u www-data -g www-data -f /usr/bin/php5-cgi -P /var/run/fastcgi-php.pid

If No input file specified is displayed when you open the php file, check the php. ini configuration.

Cgi. fix_pathinfo = 1

Doc_root =

In addition, you must set different directories for each virtual machine based on its own virtual machine to ensure that the path is correct.

Check the configuration file in/etc/nginx/sites-available. The server contains the root and root address, not the root address in the location.

Start

fast-cgisudo /usr/bin/spawn-fcgi -a 127.0.0.1 -p 9000 -C 5 -u www-data -g www-data -f /usr/bin/php5-cgi -P /var/run/fastcgi-php.pid

The parameter description is as follows:

*-F specifies the location of the execution program of the process that calls FastCGI, which is set according to the PHP installed on the system
*-A is bound to the addr address.
*-P bind to the port
*-S is the path to bind to the unix socket
*-C indicates the number of FastCGI processes generated. the default value is 5 (for PHP only)
*-P specifies the PID file path of the generated process
* What identity does-u and-g FastCGI use (-u user-g user group) to run? www-data can be used in Ubuntu, and others can be configured as needed, for example, nobody, apache, etc. now you can test a probe or php file in the web root directory.

8. install mysql

sudo apt-get install mysql-server mysql-client

In the middle, you will be prompted to enter the Root user password and enter it in sequence.

Start MySQL

Sudo/etc/init. d/mysql start

Test whether the mysql service is normal:

Run

Mysql-uroot-p

Enter the mysql password

Show databases;

If you see the following content

| Database |
| Information_schema |
| Mysql |

Mysql is correctly installed.

So far, nginx + php + mysql installation in ubuntu is complete.