{"id":98,"date":"2017-06-30T05:15:37","date_gmt":"2017-06-30T05:15:37","guid":{"rendered":"https:\/\/oimi.me\/?p=98"},"modified":"2017-06-30T05:15:37","modified_gmt":"2017-06-30T05:15:37","slug":"debian-9-x-stretch-%e4%bd%bf%e7%94%a8%e5%ae%98%e6%96%b9%e6%89%93%e5%8c%85%e6%ba%90%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac-lemp-lnmp","status":"publish","type":"post","link":"https:\/\/myya.net\/index.php\/2017\/06\/30\/debian-9-x-stretch-%e4%bd%bf%e7%94%a8%e5%ae%98%e6%96%b9%e6%89%93%e5%8c%85%e6%ba%90%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac-lemp-lnmp\/","title":{"rendered":"Debian 9.x \u201cstretch\u201d \u4f7f\u7528\u5b98\u65b9\u6253\u5305\u6e90\u5b89\u88c5\u6700\u65b0\u7248\u672c LEMP \/ LNMP"},"content":{"rendered":"

\"\"<\/p>\n

Debian 9 \u4ee3\u53f7 Stretch<\/a> \u5728 2017 \u5e74 6 \u6708 18 \u53f7\u6b63\u5f0f\u53d1\u5e03\uff0c\u7531\u4e8e\u662f\u6700\u65b0\u7684\u7cfb\u7edf\uff0c\u539f\u6765\u57fa\u4e8e Dotdeb \u5b89\u88c5\u6700\u65b0 LEMP \u7684\u6559\u7a0b\u5df2\u7ecf\u8fc7\u65f6\uff0c\u672c\u6587\u5c06\u4ecb\u7ecd\u4f7f\u7528\u5b98\u65b9\u6e90\u548c\u7b2c\u4e09\u65b9\u6e90\u5728 Debian 9.x Stretch \u5b89\u88c5\u6700\u65b0\u7248 LEMP \u7684\u6559\u7a0b\uff0c\u5e76\u4e14\u53ef\u4ee5\u81ea\u884c\u9009\u62e9 PHP \u7248\u672c\u3002<\/p>\n

PS\uff1a\u672c\u6587\u540c\u65f6\u9002\u7528\u4e8e Debian 8.x Jessie \u5982\u679c\u60a8\u7684\u670d\u52a1\u5546\u6682\u672a\u63d0\u4f9b Debian 9.x \u4e5f\u53ef\u4ee5\u51d1\u5408\u4e00\u7528<\/strong><\/p>\n

\u4ee5\u4e0b\u5b89\u88c5\u6b65\u9aa4\u90fd\u5728 root<\/code> \u7528\u6237\u4e0b\u5b8c\u6210\uff0c\u8bf7\u81ea\u884c\u4f7f\u7528 su<\/code> \u547d\u4ee4\u5207\u6362\u5230 root<\/code>\u7528\u6237<\/p>\n

<\/span>1\u3001\u66f4\u65b0\u7cfb\u7edf\u5e76\u5b89\u88c5\u90e8\u5206\u5fc5\u8981\u8f6f\u4ef6<\/h2>\n
apt-get update<\/span> && apt-get<\/span> upgrade<\/span>  \napt-get<\/span> install<\/span> curl vim wget sudo unzip apt-transport-https lsb-release<\/span> ca-certificates  \n<\/code><\/pre>\n
cat >> <\/span>\/etc\/apt\/sources.list.d\/backports.list << EOF  \ndeb http:<\/span>\/\/ftp.debian.org\/debian<\/span> $(lsb_release -sc)-backports main  \nEOF  \n<\/code><\/pre>\n
\u540e\u7eed\u7b49 Backports \u9646\u7eed\u6709\u65b0\u7248\u672c\u7684\u8f6f\u4ef6\u540e\uff0c\u4e5f\u53ef\u4ee5\u6267\u884c\u5347\u7ea7<\/p>\n
apt-get -t stretch-backports update<\/span> && apt-get<\/span> -t stretch-backports upgrade<\/span>  \n<\/code><\/pre>\n
\u5f53\u7136\u73b0\u5728\u6682\u65f6\u6ca1\u5fc5\u8981\uff0c\u5426\u5219\u4f1a\u63d0\u793a<\/p>\n
E: The value 'stretch-backports'<\/span> is<\/span> invalid for<\/span> APT::Default-Release as<\/span> such a release is<\/span> not<\/span> available in<\/span> the sources  \n<\/code><\/pre>\n
<\/span>2.1 \u9996\u5148\u589e\u52a0 Key<\/h3>\n
wget http:\/\/nginx.org\/keys\/nginx_signing.key  <\/span>\napt-key add<\/span> nginx_signing.key  \n<\/code><\/pre>\n
<\/span>2.2 \u7136\u540e\u589e\u52a0 Nginx \u5b98\u65b9\u6e90<\/h3>\n
cat >> <\/span>\/etc\/apt\/sources.list.d\/nginx.list << EOF  \ndeb http:<\/span>\/\/nginx.org\/packages<\/span>\/debian\/<\/span> $(lsb_release -sc) nginx  \ndeb-src http:<\/span>\/\/nginx.org\/packages<\/span>\/debian\/<\/span> $(lsb_release -sc) nginx  \nEOF  \n<\/code><\/pre>\n
<\/span>2.3 \u63a5\u7740\u66f4\u65b0\u5e76\u63a5\u5b89\u88c5 Nginx<\/h3>\n
apt-get update<\/span>  \napt-get<\/span> install<\/span> nginx  \n<\/code><\/pre>\n
\u6ce8\u610f\uff1a\u4e0d\u8981\u5b89\u88c5 nginx-extras<\/code> \u8fd9\u4e2a\u5305\u662f Debian \u5b98\u65b9\u6253\u5305\u7684\uff0c\u800c\u4e0d\u662f Nginx \u5b98\u65b9\u6253\u5305\u3002<\/p>\n
\u5b89\u88c5\u5b8c\u6bd5\u540e\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 nginx -v<\/code> \u547d\u4ee4\u770b\u5230 Nginx \u5df2\u7ecf\u662f\u6700\u65b0\u7684 1.12.0 \u7a33\u5b9a\u7248\u4e86<\/p>\n
root@debian9 ~ # nginx -v  <\/span>\nnginx version: nginx\/1.12<\/span>.0<\/span>  \n<\/code><\/pre>\n
<\/span>3\u3001\u4fee\u6539 Nginx \u914d\u7f6e<\/h2>\n
\u7531\u4e8e Nginx \u5b98\u65b9\u6253\u5305\u7684\u6e90\u57fa\u672c\u53ea\u662f\u4e2a\u6700\u5c0f\u5316 Nginx\uff0c\u6240\u4ee5\u6211\u4eec\u6709\u5fc5\u8981\u9488\u5bf9\u6027\u4fee\u6539\uff0c\u9996\u5148\uff0c\u53ef\u4ee5\u4fee\u6539 \/etc\/nginx\/nginx.conf<\/code> \uff0c\u53c2\u8003\u5185\u5bb9\u5982\u4e0b<\/p>\n
user<\/span> www-data;  \nworker_processes<\/span> auto;  \npid<\/span> \/run\/nginx.pid;\n\nevents<\/span> {  \n    worker_connections<\/span> 768<\/span>;\n    # multi_accept on;<\/span>\n}\n\nhttp<\/span> {\n\n    ##<\/span>\n    # Basic Settings<\/span>\n    ##<\/span>\n\n    sendfile<\/span> on<\/span>;\n    tcp_nopush<\/span> on<\/span>;\n    tcp_nodelay<\/span> on<\/span>;\n    keepalive_timeout<\/span> 65<\/span>;\n    types_hash_max_size<\/span> 2048<\/span>;\n    server_tokens<\/span> off<\/span>;\n\n    # server_names_hash_bucket_size 64;<\/span>\n    # server_name_in_redirect off;<\/span>\n\n    include<\/span> \/etc\/nginx\/mime.types;\n    default_type<\/span> application\/octet-stream;\n\n    ##<\/span>\n    # Logging Settings<\/span>\n    ##<\/span>\n\n    access_log<\/span> \/var\/log\/nginx\/access.log;\n    error_log<\/span> \/var\/log\/nginx\/error.log;\n\n    ##<\/span>\n    # Gzip Settings<\/span>\n    ##<\/span>\n\n    gzip<\/span> on<\/span>;\n    gzip_disable<\/span> \"msie6\"<\/span>;\n\n    gzip_vary<\/span> on<\/span>;\n    gzip_proxied<\/span> any;\n    gzip_comp_level<\/span> 6<\/span>;\n    gzip_buffers<\/span> 16<\/span> 8k<\/span>;\n    gzip_http_version<\/span> 1<\/span>.1<\/span>;\n    gzip_types<\/span> text\/plain text\/css application\/json application\/javascript text\/xml application\/xml application\/xml+rss text\/javascript;\n\n    ##<\/span>\n    # Virtual Host Configs<\/span>\n    ##<\/span>\n\n    include<\/span> \/etc\/nginx\/conf.d\/*.conf<\/span>;\n    include<\/span> \/etc\/nginx\/sites-enabled\/*;\n}\n<\/code><\/pre>\n
\u5220\u9664\u9ed8\u8ba4\u7684 default.conf<\/code><\/p>\n
rm -rf \/etc\/nginx\/conf.d\/default<\/span>.conf  \n<\/code><\/pre>\n
\u65b0\u5efa\u7acb\u4e00\u4e2a sites-enabled<\/code> \u76ee\u5f55\u7528\u6765\u5b58\u653e\u7f51\u7ad9\u914d\u7f6e<\/p>\n
mkdir<\/span> -p \/etc\/nginx\/sites-enabled  \n<\/code><\/pre>\n
\u4e3a\u4e86\u907f\u514d\u6240\u6709\u7f51\u7ad9\u6587\u4ef6\u90fd\u4f7f\u7528\u4e00\u5806\u91cd\u590d\u7684\u914d\u7f6e\u6587\u4ef6\uff0c\u6211\u4eec\u53ef\u4ee5\u53c2\u8003 Debian \u7684 Nginx \u914d\u7f6e<\/a>\uff0c\u628a\u4e00\u4e9b PHP \u914d\u7f6e\u6587\u4ef6\u5355\u72ec\u63d0\u53d6\u51fa\u6765<\/p>\n
\u65b0\u5efa \/etc\/nginx\/fastcgi.conf<\/code> \u5185\u5bb9\u5982\u4e0b<\/p>\n
fastcgi_param<\/span>  SCRIPT_FILENAME    $document_root<\/span>$fastcgi_script_name<\/span>;  \nfastcgi_param<\/span>  QUERY_STRING       $query_string<\/span>;  \nfastcgi_param<\/span>  REQUEST_METHOD     $request_method<\/span>;  \nfastcgi_param<\/span>  CONTENT_TYPE       $content_type<\/span>;  \nfastcgi_param<\/span>  CONTENT_LENGTH     $content_length<\/span>;\n\nfastcgi_param<\/span>  SCRIPT_NAME        $fastcgi_script_name<\/span>;  \nfastcgi_param<\/span>  REQUEST_URI        $request_uri<\/span>;  \nfastcgi_param<\/span>  DOCUMENT_URI       $document_uri<\/span>;  \nfastcgi_param<\/span>  DOCUMENT_ROOT      $document_root<\/span>;  \nfastcgi_param<\/span>  SERVER_PROTOCOL    $server_protocol<\/span>;  \nfastcgi_param<\/span>  REQUEST_SCHEME     $scheme<\/span>;  \nfastcgi_param<\/span>  HTTPS              $https<\/span> if_not_empty;\n\nfastcgi_param<\/span>  GATEWAY_INTERFACE  CGI\/1<\/span>.1<\/span>;  \nfastcgi_param<\/span>  SERVER_SOFTWARE    nginx\/$nginx_version<\/span>;\n\nfastcgi_param<\/span>  REMOTE_ADDR        $remote_addr<\/span>;  \nfastcgi_param<\/span>  REMOTE_PORT        $remote_port<\/span>;  \nfastcgi_param<\/span>  SERVER_ADDR        $server_addr<\/span>;  \nfastcgi_param<\/span>  SERVER_PORT        $server_port<\/span>;  \nfastcgi_param<\/span>  SERVER_NAME        $server_name<\/span>;\n\n# PHP only, required if PHP was built with --enable-force-cgi-redirect<\/span>\nfastcgi_param<\/span>  REDIRECT_STATUS    200<\/span>;  \n<\/code><\/pre>\n
\u5176\u5b9e\u8fd9\u4e2a\u6587\u4ef6\u548c \/etc\/nginx\/fastcgi_params<\/code> \u7684\u533a\u522b\u5c31\u662f\u7b2c\u4e00\u884c\u589e\u52a0\u4e86<\/p>\n
fastcgi_param<\/span>  SCRIPT_FILENAME    $document_root<\/span>$fastcgi_script_name<\/span>;  \n<\/code><\/pre>\n
\u7136\u540e\u65b0\u5efa\u7acb\u4e2a snippets<\/code> \u76ee\u5f55<\/p>\n
mkdir<\/span> -p \/etc\/nginx\/snippets  \n<\/code><\/pre>\n
\u589e\u52a0\u4e00\u4e2a \/etc\/nginx\/snippets\/fastcgi-php.conf<\/code> \u5185\u5bb9\u5982\u4e0b<\/p>\n
# regex to split $uri to $fastcgi_script_name and $fastcgi_path<\/span>\nfastcgi_split_path_info<\/span> ^(.+\\.php)(\/.+)$<\/span>;\n\n# Check that the PHP script exists before passing it<\/span>\ntry_files<\/span> $fastcgi_script_name<\/span> =404<\/span>;\n\n# Bypass the fact that try_files resets $fastcgi_path_info<\/span>\n# see: http:\/\/trac.nginx.org\/nginx\/ticket\/321<\/span>\nset<\/span> $path_info<\/span> $fastcgi_path_info<\/span>;  \nfastcgi_param<\/span> PATH_INFO $path_info<\/span>;\n\nfastcgi_index<\/span> index.php;  \ninclude<\/span> fastcgi.conf;  \n<\/code><\/pre>\n
\u6d4b\u8bd5 Nginx \u914d\u7f6e\u6587\u4ef6\u8bed\u6cd5\u662f\u5426\u6b63\u786e<\/p>\n
nginx<\/span> -t  \n<\/code><\/pre>\n
\u5982\u679c\u6ca1\u6709\u95ee\u9898\uff0c\u5219\u8f93\u51fa\u5982\u4e0b<\/p>\n
root@debian9 ~ # nginx -t  <\/span>\nnginx: the configuration file \/etc\/nginx\/nginx.conf syntax is<\/span> ok  \nnginx: configuration file \/etc\/nginx\/nginx.conf test is<\/span> successful  \n<\/code><\/pre>\n
\u5982\u679c\u5c0f\u4f19\u4f34\u4eec\u5bf9\u8fd9\u4e2a\u6b65\u9aa4\u89c9\u5f97\u9ebb\u70e6\uff0c\u90a3\u4e48\uff0c\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528\u6211\u6309\u7167 Debian \u5b98\u65b9\u6e90\u7684\u914d\u7f6e\u6587\u4ef6\u5bf9\u6bd4 Nginx \u5b98\u65b9\u6e90\u7684\u914d\u7f6e\u6587\u4ef6\u4fee\u6539\u597d\u7684 \/etc\/nginx<\/code> \u76ee\u5f55\uff0c\u55ef\uff0c\u4ec5\u9002\u5408\u65b0\u5f00\u7684\u673a\u5668\u54e6\uff0c\u4f7f\u7528\u524d\u8bf7\u5148\u505a\u597d\u5907\u4efd\uff0c\u5426\u5219\u540e\u679c\u81ea\u8d1f<\/p>\n
rm -rf \/etc\/nginx\/* && cd<\/span> \/etc\/nginx && wget \"https:\/\/sb.sb.sb\/nginx\/nginx-conf-latest.zip\"<\/span> && unzip nginx-conf-latest.zip && install -o www-data -g www-data -d<\/span> \/var\/www  \n<\/code><\/pre>\n
\u7136\u540e\u5c31\u53ef\u4ee5\u7ee7\u7eed\u5f80\u4e0b\u770b\u4e86<\/p>\n
<\/span>4.1 \u589e\u52a0\u5927\u795e\u7684 PGP<\/h3>\n
wget<\/span> -O \/etc\/apt\/trusted.gpg.d\/php.gpg https:\/\/packages.sury.org\/php\/apt.gpg  \n<\/code><\/pre>\n
<\/span>4.2 \u52a0\u5165\u5927\u795e\u505a\u597d\u7684\u6e90<\/h3>\n
sh<\/span> -c 'echo \"deb https:\/\/packages.sury.org\/php\/ $(lsb_release -sc) main\" > \/etc\/apt\/sources.list.d\/php.list'<\/span>  \n<\/code><\/pre>\n
<\/span>4.3 \u66f4\u65b0\u7cfb\u7edf<\/h3>\n
apt-get<\/span> update  \n<\/code><\/pre>\n
<\/span>4.4 \u5b89\u88c5\u81ea\u5df1\u9700\u8981\u7684 PHP \u7248\u672c<\/h3>\n
\u8fd9\u4e2a\u6e90\u76ee\u524d\u9ed8\u8ba4\u7684 PHP \u662f 7.1.x \uff0c\u5982\u679c\u60a8\u9700\u8981 7.0.x \u6216\u8005 5.6.x \u90a3\u4e48\u8bf7\u4fee\u6539\u5bf9\u5e94\u7684 PHP \u7248\u672c\u53f7\uff08\u6ce8\u610f\u914d\u7f6e\u6587\u4ef6\u54e6\uff09<\/p>\n
\u8fd9\u91cc\u4e3e\u4f8b WordPress \u9700\u8981\u7684\u90e8\u5206 PHP \u5305<\/p>\n
apt-get<\/span> install<\/span> php7<\/span>.1-fpm<\/span> php7<\/span>.1-mysql<\/span> php7<\/span>.1-curl<\/span> php7<\/span>.1-gd<\/span> php7<\/span>.1-mbstring<\/span> php7<\/span>.1-mcrypt<\/span> php7<\/span>.1-xml<\/span> php7<\/span>.1-xmlrpc<\/span> php7<\/span>.1-zip<\/span>  \n<\/code><\/pre>\n
\u5bf9\u5e94 PHP 7.0.x \u5c31\u662f<\/p>\n
apt-get<\/span> install<\/span> php7<\/span>.0-fpm<\/span> php7<\/span>.0-mysql<\/span> php7<\/span>.0-curl<\/span> php7<\/span>.0-gd<\/span> php7<\/span>.0-mbstring<\/span> php7<\/span>.0-mcrypt<\/span> php7<\/span>.0-xml<\/span> php7<\/span>.0-xmlrpc<\/span> php7<\/span>.0-zip<\/span>  \n<\/code><\/pre>\n
\u4fee\u6539 php.ini<\/code> \u9632\u6b62\u8de8\u76ee\u5f55\u653b\u51fb\uff0c\u5982\u679c\u5b89\u88c5\u7684 PHP 7.0.x \u8bf7\u76f8\u5e94\u4fee\u6539 \/etc\/php\/7.0\/fpm\/php.ini<\/code><\/p>\n
sed<\/span> -i 's\/;cgi.fix_pathinfo=1\/cgi.fix_pathinfo=0\/'<\/span> \/etc\/php\/7<\/span>.1<\/span>\/fpm\/php.ini  \n<\/code><\/pre>\n
<\/span>4.5 \u91cd\u542f PHP \u548c Nginx<\/h3>\n
systemctl<\/span> restart<\/span> php7<\/span>.1-fpm<\/span>  \n<\/code><\/pre>\n
\u5bf9\u5e94 PHP 7.0.x \u547d\u4ee4\u5982\u4e0b<\/p>\n
systemctl<\/span> restart<\/span> php7<\/span>.0-fpm<\/span>  \n<\/code><\/pre>\n
Nginx \u53c2\u8003\u914d\u7f6e\u6587\u4ef6\u5982\u4e0b\uff0c\u65b0\u5efa\u7acb\u4e2a \/etc\/nginx\/sites-enabled\/example.com.conf<\/code> \u6216\u76f4\u63a5\u4ece\u672c\u7ad9\u63d0\u4f9b\u7684\u914d\u7f6e\u6587\u4ef6<\/a> \/etc\/nginx\/sites-available\/default-example-php-fpm-7.1.conf<\/code> \u53c2\u8003\u4fee\u6539<\/p>\n
server<\/span> {  \n        listen<\/span> 80<\/span>;\n        listen<\/span> [::]:80<\/span>;\n\n# \u6307\u5b9a\u7f51\u7ad9\u76ee\u5f55\uff0c\u53ef\u6839\u636e\u81ea\u5df1\u60c5\u51b5\u66f4\u6362\uff0c\u5efa\u8bae\u653e\u5728 \/var\/www \u76ee\u5f55\u4e0b<\/span>\n        root<\/span> \/var\/www\/example.com;\n        index<\/span> index.php index.html index.htm;\n\n# \u9ed8\u8ba4\u7b2c\u4e00\u4e2a\u57df\u540d\uff0c\u66ff\u6362 example.com \u4e3a\u60a8\u7684\u57df\u540d<\/span>\n        server_name<\/span> example.com;\n\n        location<\/span> \/ {\n            try_files<\/span> $uri<\/span> $uri<\/span>\/ =404<\/span>;\n        }\n\n# \u5f00\u542f PHP7.1-fpm \u6a21\u5f0f\uff0c\u5982\u9700\u8981\u5b89\u88c5 PHP 7.0.x \u8bf7\u4fee\u6539\u4e3a fastcgi_pass unix:\/run\/php\/php7.0-fpm.sock;<\/span>\n        location<\/span> ~ \\.php$<\/span> {\n            include<\/span> snippets\/fastcgi-php.conf;\n            fastcgi_pass<\/span> unix:\/run\/php\/php7.1-fpm.sock;\n        }\n}\n<\/code><\/pre>\n
\u5230\u8fd9\u91cc\u57fa\u672c\u6ca1\u6709\u95ee\u9898\uff0c\u53ef\u4ee5\u76f4\u63a5\u91cd\u542f Nginx<\/p>\n
systemctl<\/span> restart nginx  \n<\/code><\/pre>\n
\u6211\u4eec\u7684\u76ee\u5f55\u5728 \/var\/www\/example.com<\/code>\uff0c \u521b\u5efa\u4e00\u4e2a phpinfo.php<\/code> \u5e76\u8f93\u5165 phpinfo()<\/code> \u51fd\u6570<\/p>\n
cat >> \/var<\/span>\/www\/example.com\/phpinfo.php << EOF  \n<?php<\/span> phpinfo(); ?><\/span>  \nEOF  \n<\/code><\/pre>\n
\u597d\u4e86\uff0c\u6b64\u65f6\u5728\u6d4f\u89c8\u5668\u8f93\u5165 http:\/\/example.com\/phpinfo.php<\/code>\uff0c\u5982\u679c\u770b\u5230\u7ecf\u5178\u7684 phpinfo<\/code> \u9875\u9762\u5219\u8bf4\u660e\u5b89\u88c5\u6210\u529f\uff0c\u5982\u679c\u4e0d\u6210\u529f\uff0c\u8bf7\u4ed4\u7ec6\u5bf9\u6bd4\u6b65\u9aa4\u67e5\u627e\u54ea\u91cc\u51fa\u9519\u6216\u5728\u70e7\u997c\u535a\u5ba2\u4e0b\u65b9\u7559\u8a00<\/p>\n
\u6548\u679c\u5982\u4e0b<\/p>\n
\"\"<\/p>\n
5\u3001\u5b89\u88c5 MySQL 5.7.x<\/h2>\n
\u7531\u4e8e\u4e4b\u524d\u4e00\u76f4\u63a8\u8350\u7684 Percona Server<\/a> \u6682\u672a\u53d1\u5e03 Debian 9.x Stretch \u7248\u672c\uff0c\u800c Debian 9.x Stretch \u9ed8\u8ba4\u5df2\u7ecf\u4f7f\u7528<\/a> Mariadb \uff0c\u6240\u4ee5\u8fd9\u91cc\u6211\u4eec\u7528 MySQL \u5b98\u65b9\u6e90\u8fdb\u884c\u5b89\u88c5<\/p>\n
<\/span>5.1 \u9996\u5148\uff0c\u5bfc\u5165 MySQL \u7684\u5b98\u65b9\u6e90<\/h3>\n
wget<\/span> https:\/\/repo.mysql.com\/mysql-apt-config_0.8.6-1_all.deb  \ndpkg -i mysql-apt-config_0.8<\/span>.6<\/span>-1_all.deb  \n<\/code><\/pre>\n
\u5f39\u51fa\u7684\u754c\u9762\u91cc\u76f4\u63a5\u9009\u62e9 MySQL Server & Cluster (Currently selected: mysql-5.7<\/code> \u5e76\u6309 tab<\/kbd> \u9009\u62e9 OK \u7136\u540e\u56de\u8f66\uff0c\u7248\u672c\u9009\u62e9 mysql-5.7<\/code> \u5e76\u6309 tab<\/kbd> \u9009\u62e9 ok \u5e76\u56de\u8f66\uff0c\u63a5\u7740\u518d\u6309 tab<\/kbd> \u9009\u62e9 OK \u7136\u540e\u56de\u8f66\u5373\u53ef\uff0c\u5982\u56fe<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
\n
5.2 \u63a5\u7740\u66f4\u65b0\u4e00\u4e0b\u7cfb\u7edf<\/h3>\n
apt-get<\/span> update  \n<\/code><\/pre>\n
<\/span>5.3 \u7136\u540e\u76f4\u63a5\u5b89\u88c5\u6700\u65b0\u7248 MySQL 5.7.x<\/h3>\n
apt-get install<\/span> mysql-server<\/span>  \n<\/code><\/pre>\n
\u5728\u5f39\u51fa\u7684\u754c\u9762\u91cc\u8f93\u5165\u4e24\u6b21\u968f\u673a\u5e76\u4e14\u5f3a\u5927\u7684 MySQL root \u5bc6\u7801\u5373\u53ef\uff0c\u5b89\u88c5\u6210\u529f\u540e\u68c0\u67e5\u4e00\u4e0b\u7248\u672c<\/p>\n
root@debian9 ~ # mysql -V  <\/span>\nmysql  Ver 14.14<\/span> Distrib 5.7<\/span>.18<\/span>, for<\/span> Linux (x86_64) using  EditLine wrapper  \n<\/code><\/pre>\n
<\/span>5.4 \u521b\u5efa\u6570\u636e\u5e93\u5e76\u6d4b\u8bd5<\/h3>\n
\u4f7f\u7528 MySQL root \u7528\u6237\u767b\u9646<\/p>\n
mysql<\/span> -u root -p  \n<\/code><\/pre>\n
\u521b\u5efa\u6570\u636e\u5e93 example_database<\/code><\/p>\n
CREATE<\/span> DATABASE<\/span> example_database DEFAULT<\/span> CHARACTER<\/span> SET<\/span> utf8mb4 COLLATE<\/span> utf8mb4_unicode_ci;  \n<\/code><\/pre>\n
\u521b\u5efa\u7528\u6237\u540d example_user<\/code> \u5e76\u8d4b\u4e88\u6743\u9650<\/p>\n
GRANT<\/span> ALL ON<\/span> example_database.* TO<\/span> 'example_user'<\/span>@'localhost'<\/span> IDENTIFIED<\/span> BY<\/span> '\u8fd9\u91cc\u6539\u6210\u4f60\u8981\u8bbe\u7f6e\u7684\u5f3a\u5927\u7684\u6ca1\u4eba\u80fd\u731c\u51fa\u6765\u7684\u968f\u673a\u7684\u5bc6\u7801'<\/span>;  \n<\/code><\/pre>\n
\u5237\u65b0 MySQL \u6743\u9650<\/p>\n
FLUSH<\/span> PRIVILEGES<\/span>;  \n<\/code><\/pre>\n
\u6ca1\u95ee\u9898\u4ee5\u540e\u5c31\u53ef\u4ee5\u9000\u51fa\u4e86<\/p>\n
EXIT<\/span>;  \n<\/code><\/pre>\n
\u65b0\u5efa\u7acb\u4e00\u4e2a \/var\/www\/example.com\/mysql-test.php<\/code> \u6587\u4ef6\u5e76\u6d4b\u8bd5<\/p>\n
cat >> \/var<\/span>\/www\/example.com\/mysql-test.php << EOF  \n<?php<\/span>  \n\\$dbname = 'example'<\/span>;    \/\/MySQL \u6570\u636e\u5e93\u540d<\/span>\n\\$dbuser = 'example_user'<\/span>;   \/\/MySQL \u7528\u6237\u540d<\/span>\n\\$dbpass = '\u4f60\u7684\u5f3a\u5927\u7684\u6ca1\u4eba\u53ef\u4ee5\u731c\u51fa\u6765\u7684\u5bc6\u7801'<\/span>;\n\\$dbhost = 'localhost'<\/span>;  \/\/\u5b89\u88c5\u5728\u672c\u5730\u5c31\u7528 localhost<\/span>\n\\$link = mysqli_connect(\\$dbhost, \\$dbuser, \\$dbpass) or<\/span> die<\/span>(\"Unable to Connect to '\\$dbhost'\"<\/span>);\nmysqli_select_db(\\$link, \\$dbname) or<\/span> die<\/span>(\"Could not open the db '\\$dbname'\"<\/span>);  \n\\$test_query = \"SHOW TABLES FROM \\$dbname\"<\/span>;\n\\$result = mysqli_query(\\$link, \\$test_query);\n\\$tblCnt = 0<\/span>;\nwhile<\/span>(\\$tbl = mysqli_fetch_array(\\$result)) {  \n  \\$tblCnt++;\n  #echo \\$tbl[0].\"&lt;br \/&gt;\\n\";<\/span>\n}\nif<\/span> (!\\$tblCnt) {  \n  echo<\/span> \"MySQL is working fine. There are no tables. More information on https:\/\/sb.sb\/tag\/mysql\/\"<\/span>;\n} else<\/span> {\n  echo<\/span> \"MySQL is working fine. There are \\$tblCnt tables. More information on https:\/\/sb.sb\/tag\/mysql\/\"<\/span>;\n}\n?><\/span>\nEOF  \n<\/code><\/pre>\n
\u521b\u5efa\u5b8c\u6bd5\u540e\u8bbf\u95ee http:\/\/example.com\/mysql-test.php<\/code> \u5982\u679c\u51fa\u73b0 MySQL is working fine. There are no tables.<\/code> \u5219\u8bf4\u660e MySQL \u5de5\u4f5c\u6b63\u5e38\u3002<\/p>\n
\u597d\u4e86\uff0c\u4ee5\u4e0a\u5c31\u662f\u57fa\u672c\u7684 Debian 9.x “Stretch” \u5b89\u88c5\u6700\u65b0\u7248 LEMP \u7684\u6559\u7a0b\uff0c\u5982\u6709\u95ee\u9898\u53ef\u4ee5\u968f\u65f6\u53d1\u8bc4\u8bba\u7559\u8a00\u8ba8\u8bba\u3002<\/p>\n<\/div>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Debian 9 \u4ee3\u53f7 Stretch \u5728 2017 \u5e74 6 \u6708 18 \u53f7\u6b63\u5f0f\u53d1\u5e03\uff0c\u7531\u4e8e\u662f\u6700\u65b0\u7684\u7cfb\u7edf\uff0c\u539f\u6765\u57fa\u4e8e […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[81,165,170,201,285],"class_list":["post-98","post","type-post","status-publish","format-standard","hentry","category-hardware","tag-debian-9","tag-lemp","tag-lnmp","tag-nginx","tag-stretch"],"_links":{"self":[{"href":"https:\/\/myya.net\/index.php\/wp-json\/wp\/v2\/posts\/98","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myya.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myya.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myya.net\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/myya.net\/index.php\/wp-json\/wp\/v2\/comments?post=98"}],"version-history":[{"count":0,"href":"https:\/\/myya.net\/index.php\/wp-json\/wp\/v2\/posts\/98\/revisions"}],"wp:attachment":[{"href":"https:\/\/myya.net\/index.php\/wp-json\/wp\/v2\/media?parent=98"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myya.net\/index.php\/wp-json\/wp\/v2\/categories?post=98"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myya.net\/index.php\/wp-json\/wp\/v2\/tags?post=98"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\u5b89\u88c5\u5b8c\u6bd5\u540e\u5f3a\u70c8\u63a8\u8350\u4f7f\u7528 mysql_secure_installation<\/code> \u547d\u4ee4\u505a\u4e00\u6b21\u5b89\u5168\u8bbe\u7f6e\uff0c\u8be6\u89c1 Ubuntu Server 16.04.x (Xenial Xerus) \u5b89\u88c5 LEMP \/ LNMP \u6559\u7a0b<\/a> \u91cc\u9762\u7684\u8bf4\u660e\uff0c\u540c\u6837\u5176\u4ed6\u7684\u914d\u7f6e\u90fd\u662f\u4e00\u6837\u7684<\/p>\n
<\/span>4\u3001\u589e\u52a0 Ond\u0159ej Sur\u00fd \u5927\u795e\u6253\u5305\u7684 PHP \u6e90\u5e76\u5b89\u88c5 PHP 7.x<\/h2>\n
Ond\u0159ej Sur\u00fd<\/a> \u662f\u4e00\u4e2a\u6765\u81ea\u6377\u514b\u7684\u5927\u4f6c\uff0cUbuntu \u7684 PPA for PHP<\/a> \u5c31\u662f\u8fd9\u4f4d\u5927\u4f6c\u505a\u7684\uff0c\u5f53\u7136\u5c11\u4e0d\u4e86 Debian \u7684\u6e90\u4e86\uff0c\u4e0b\u9762\u4e00\u6b65\u4e00\u6b65\u6765<\/p>\n
\u5982\u679c\u6ca1\u6709\u8fd9\u884c\u4ee3\u7801\uff0c\u90a3\u4e48 PHP-FPM<\/a> (FastCGI Process Manager) \u5c31\u6ca1\u6cd5\u6267\u884c\u5f53\u524d\u76ee\u5f55\u4e0b\u7684\u6587\u4ef6\uff0c\u4ece\u800c\u9020\u6210 502 \u9519\u8bef<\/p>\n
<\/span>2\u3001\u589e\u52a0 Nginx \u5b98\u65b9\u6e90\u5e76\u5b89\u88c5<\/h2>\n
\u7531\u4e8e Debian \u5b98\u65b9\u6253\u5305\u7ec4\u5728 2 \u6708\u4efd\u5c31\u5df2\u7ecf\u622a\u6b62\u6253\u5305\u6240\u6709\u8f6f\u4ef6\uff0c\u6240\u4ee5 Nginx \u5728\u5b98\u65b9\u6e90<\/a>\u91cc\u4e00\u76f4\u505c\u7559\u5728 1.10.3<\/a> \u800c 1.12.0<\/a> \u5df2\u7ecf\u53d1\u5e03\u4e24\u4e2a\u6708\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 Nginx \u5b98\u65b9\u7684\u6e90\u8fdb\u884c\u5b89\u88c5<\/p>\n
\u6309\u7167 Nginx \u5b98\u7f51\u7684\u8bf4\u660e<\/a><\/p>\n
\u7531\u4e8e Debian 9.x \u521a\u53d1\u5e03\uff0c Backports<\/a>\u76ee\u524d\u8fd8\u6ca1\u6709\u8f6f\u4ef6\uff0c\u5982\u6709\u540e\u7eed\u5347\u7ea7\u7684\u5fc5\u8981\uff0c\u4e5f\u53ef\u4ee5\u52a0\u5165 Backports \u6e90\uff0c\u65b9\u4fbf\u672a\u6765\u5347\u7ea7<\/p>\n