phpMyAdmin + nginx + php-fpm на Debian 9

Установка и настройка nginx + php + phpMyAdmin под Debian 9…

Устанавливаем nginx

apt install nginx

Устанавливаем PHP-FPM

apt install php7.0-fpm php7.0-cgi php7.0-mcrypt php7.0-gd php7.0-mysqli

Настраиваем nginx и приводим файл /etc/nginx/nginx.conf к виду…

user www-data;
worker_processes auto;
pid /run/nginx.pid;
include /etc/nginx/modules-enabled/*.conf;

events {
 worker_connections 1025;
 # multi_accept on;
 use epoll;
}

http {

 ##
 # Basic Settings
 ##

 sendfile on;
 tcp_nopush on;
 tcp_nodelay on;
 keepalive_timeout 65;
 types_hash_max_size 2048;
 # server_tokens off;

 # server_names_hash_bucket_size 64;
 # server_name_in_redirect off;

 include /etc/nginx/mime.types;
 default_type application/octet-stream;

 ##
 # SSL Settings
 ##

 ssl_protocols TLSv1 TLSv1.1 TLSv1.2; # Dropping SSLv3, ref: POODLE
 ssl_prefer_server_ciphers on;

 ##
 # Logging Settings
 ##

 access_log /var/log/nginx/access.log;
 error_log /var/log/nginx/error.log;

 ##
 # Gzip Settings
 ##

 gzip on;
 gzip_disable "msie6";

 # gzip_vary on;
 # gzip_proxied any;
 # gzip_comp_level 6;
 # gzip_buffers 16 8k;
 # gzip_http_version 1.1;
 # gzip_types text/plain text/css application/json application/javascript text/xml application/xml application/xml+rss text/javascript;

 ##
 # Virtual Host Configs
 ##

 include /etc/nginx/conf.d/*.conf;
 include /etc/nginx/sites-enabled/*;
}

Далее в /etc/nginx/sites-enabled создаем файл dimanao.cf.conf (ставить свой домен)

server {
  listen 80;

  server_name dimanao.cf;
  charset utf-8;

  root /var/www/dimanao.cf;
  index index.html index.htm index.php;

  access_log /var/log/nginx/dimanao.cf_access.log;
  error_log /var/log/nginx/dimanao.cf_error.log;
  include /etc/nginx/templates/php-fpm.conf;

    listen 443 ssl; # managed by Certbot
    ssl_certificate /etc/letsencrypt/live/dimanao.cf/fullchain.pem; # managed by Certbot
    ssl_certificate_key /etc/letsencrypt/live/dimanao.cf/privkey.pem; # managed by Certbot
    include /etc/letsencrypt/options-ssl-nginx.conf; # managed by Certbot
    ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem; # managed by Certbot


    if ($scheme != "https") {
        return 301 https://$host$request_uri;
    } # managed by Certbot

   location /sqlad/ {                               
            alias       /usr/share/phpmyadmin/;
            index       index.html index.htm index.php;
        }       

}

server {
 
  listen 80; 
 
  server_name dimanao.cf;
  rewrite ^(.*) http://dimanao.cf$1 permanent;
}

Устанавливаем phpmyadmin

apt install phpmyadmin

ln -s /usr/share/phpmyadmin /var/www/dimanao.cf/sqlad

Устанавливаем mysql и создаём пользователя

apt install mysql-server mysql-client

mysql -u root -p
USE mysql;
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Разрешаем пользователю root подключаться к MySQL без sudo

mysql -u root -p
USE mysql;
UPDATE user set plugin='' where User='root';
FLUSH PRIVILEGES;
quit