Ngày 02 - Cài đặt Drupal site

My SQL Commands

Connect

mysql -u root -proot -h localhost


Exit

ctrl+c

quit;


Show database

SHOW DATABASES;


Create new user:

CREATE USER 'drupal'@'localhost' IDENTIFIED BY 'drupalpass';


Create new database:

CREATE DATABASE drupal_training


Grant user to database

GRANT ALL PRIVILEGES ON *.* TO 'drupal'@'%'

Nginx Configuration

server {

server_name training.drupal.local;

listen 192.168.56.115:80;

root /var/www/training.drupal.local;


location = /favicon.ico {

log_not_found off;

access_log off;

}


location = /robots.txt {

allow all;

log_not_found off;

access_log off;

}


# This matters if you use drush

location = /backup {

deny all;

}


# Very rarely should these ever be accessed outside of your lan

location ~* \.(txt|log)$ {

allow 192.168.0.0/16;

deny all;

}


location ~ \..*/.*\.php$ {

return 403;

}


location / {

# This is cool because no php is touched for static content

try_files $uri @rewrite;

}


location @rewrite {

# Some modules enforce no slash (/) at the end of the URL

# Else this rewrite block wouldn't be needed (GlobalRedirect)

rewrite ^/(.*)$ /index.php?q=$1;

}


location ~ \.php$ {

fastcgi_split_path_info ^(.+\.php)(/.+)$;

#NOTE: You should have "cgi.fix_pathinfo = 0;" in php.ini

include fastcgi_params;

fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

fastcgi_intercept_errors on;

fastcgi_pass 127.0.0.1:9000;

}


# Fighting with ImageCache? This little gem is amazing.

location ~ ^/sites/.*/files/imagecache/ {

try_files $uri @rewrite;

}

# Catch image styles for D7 too.

location ~ ^/sites/.*/files/styles/ {

try_files $uri @rewrite;

}


location ~* \.(js|css|png|jpg|jpeg|gif|ico)$ {

expires max;

log_not_found off;

}

}