如何用WordPress + Nginx + MySQL + PHP搭建个人博客

sudo apt install unzip

unzip wordpress-5.2.1.zip

sudo apt install php

whereis php-fpm

service php7.2-fpm start

sudo apt install nginx

service nginx start

sudo apt install mysql-server
sudo apt install mysql-client
sudo apt install libmysqlclient-dev

sudo netstat -tap | grep mysql

# 替换*adminusername*为你的数据库用户名
$ mysql -u *adminusername* -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5340 to server version: 3.23.54
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

# 创建WordPress数据库，替换*databasename*为数据库名称，如blogdb
mysql> CREATE DATABASE *databasename*;
Query OK, 1 row affected (0.00 sec)

# 替换dabasename, wordpressusername, hostname和password。hostname通常是localhost
mysql> GRANT ALL PRIVILEGES ON databasename.* TO "wordpressusername"@"hostname"
    -> IDENTIFIED BY "password";
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
mysql> EXIT
Bye
$

$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5340 to server version: 3.23.54
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE DATABASE blogdb;
Query OK, 1 row affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON blogdb.* TO "wendi"@"localhost"
    -> IDENTIFIED BY "mypassword";
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
mysql> EXIT
Bye
$

server {
    # 【更改点1】因为我们要使用域名访问，这里删除default_server
    listen 80;
    listen [::]:80;

    # 【更改点2】网站根目录，默认路径为/var/www/html
    # 为了便于管理，我建立了路径/var/www/www.wendicai.net为我的网站根目录
    # 如果使用非默认路径，需要将原路径/var/www/html/下的所有文件拷贝到新路径中
    root /var/www/www.wendicai.net;

    #【更改点3】在index.html前加上index.php，以支持WordPress
    # Add index.php to the list if you are using PHP
    index index.php index.html index.htm index.nginx-debian.html;

    #【更改点4】替换“_”为我们申请好的域名
    server_name www.wendicai.net;
    location / {
        # First attempt to serve request as file, then
        # as directory, then fall back to displaying a 404.
        try_files $uri $uri/ =404;
    }

    #【更改点5】取消此部分注释，因为WordPress需要用到PHP。如果安装的PHP版本不是7.0，需要手动改下版本号
    # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
    #
    location ~ \.php$ {
        include snippets/fastcgi-php.conf;
    #
    #   # With php7.0-cgi alone:
    #   fastcgi_pass 127.0.0.1:9000;
    #   # With php7.0-fpm:
        fastcgi_pass unix:/run/php/php7.0-fpm.sock;
    }

    # deny access to .htaccess files, if Apache's document root
    # concurs with nginx's one
    #
    location ~ /\.ht {
        deny all;
    }
}

sudo service nginx restart

root@WebServer:/var/www# ls
www.wendicai.net  www.xia-weiwen.com

root@Ubuntu:/etc/nginx/vhost# ls
vhost_wendicai.conf  vhost_xia-weiwen.conf

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

    # 添加新配置文件所在路径/etc/nginx/vhost/*.conf
    include /etc/nginx/vhost/*.conf; 
}

service nginx restart

lsof -i:80

chmod -R 777 /var/www/www.wendicai.net # 网站根目录

apt-get install php7.2-gd

function iesay_filter_chinese_excerpt( $output ) {
global $post;
//check if its chinese character input
$chinese_output = preg_match_all("/\p{Han}+/u", $post->post_content, $matches);
if($chinese_output) {
$output = mb_substr( $output, 0, 100 ) . '...';
}
return $output;
}
add_filter( 'get_the_excerpt', 'iesay_filter_chinese_excerpt' );

function ie_longer_excerpts( $length ) {
  // Don't change anything inside /wp-admin/
  if ( is_admin() ) {
    return $length;
  }
  // Set excerpt length to 50 words
  return 50;
}
// "999" priority makes this run last of all the functions hooked to this filter, meaning it overrides them
add_filter( 'excerpt_length', 'ie_longer_excerpts', 999 );

function autoblank($text) {
    $return = str_replace('<a', '<a target="_blank"', $text);
    return $return;
}
add_filter('the_content', 'autoblank');

update_option( 'siteurl', 'http://www.wendicai.net' );
update_option( 'home', 'https://www.wendicai.net' );