MariaDB

mkdir -p ~/db/MariaDB && cd ~/db/MariaDB
nano docker-compose.yml
sudo docker-compose up -d

version: "2.1"
services:
  mariadb:
    image: linuxserver/mariadb:latest
    container_name: mariadb
    environment:
      - PUID=1000
      - PGID=1000
      - MYSQL_ROOT_PASSWORD=ROOT_ACCESS_PASSWORD
      - TZ=Asia/Shanghai
    volumes:
      - ./config:/config
    ports:
      - 3306:3306
    restart: unless-stopped

拉取镜像

mkdir -p ~/app/WordPress && cd ~/app/WordPress && nano docker-compose.yml
sudo docker-compose up -d
# 反代 8081

version: '3.1'
services:
  wordpress:
    image: wordpress
    restart: always
    ports:
      - 8081:80
    environment:
      WORDPRESS_DB_HOST: 172.17.0.1
      WORDPRESS_DB_USER: wordpress
      WORDPRESS_DB_PASSWORD: examplepass
      WORDPRESS_DB_NAME: wordpress
    volumes:
      - ./www:/var/www/html

创建数据库

• cd ~/app/WordPress/www
• wget https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php -O .php
• 访问 limour.top/.php
• 服务器：172.17.0.1
• 用户名：root
• 密码：ROOT_ACCESS_PASSWORD

点击“创建新数据库”进行创建数据库

• 左侧输入框填写数据库名字 wordpress
• 右边的编码选择 utf8mb4_general_ci

创建访问该数据库的用户

• 创建好数据库之后，默认进入该数据库的表和视图，在该界面点击“权限”链接
• 在此界面点击“创建用户”链接
• 权限 勾选 All privileges
• 用户名 wordpress
• 密码 examplepass

WordPress初始化

• 访问 limour.top
• 按提示完成初始化

优化小细节

if(isset($_SERVER['HTTP_X_REAL_IP'])) {
    $list = explode(',',$_SERVER['HTTP_X_REAL_IP']);
    $_SERVER['REMOTE_ADDR'] = $list[0];
    $_SERVER['HTTPS']='on';   
    $_SERVER["SERVER_PORT"] = 443;
    define('WP_HOME', 'https://'.$_SERVER['HTTP_HOST']);
    define('WP_SITEURL', 'https://'.$_SERVER['HTTP_HOST']);
    define('WP_CONTENT_URL', 'https://'.$_SERVER['HTTP_HOST'].'/wp-content');
    define('FORCE_SSL_LOGIN', true);
    define('FORCE_SSL_ADMIN', true);
}

• nano ~/app/WordPress/www/wp-config.php’
• 添加以上代码

安装实用插件

• Easy WP SMTP
• WP-Optimize

安装Sakurairo主题

• 下载主题文件
• 按说明完成Sakurairo安装

解除php文件上传的大小限制

sudo docker exec -it wordpress-wordpress-1 bash
php -i | grep php.ini
ls /usr/local/etc/php
exit
cd ~/app/WordPress
sudo docker cp wordpress-wordpress-1:/usr/local/etc/php/php.ini-production ./php.ini
nano ./php.ini
upload_max_filesize = 20M
post_max_size = 20M
sudo docker cp ./php.ini wordpress-wordpress-1:/usr/local/etc/php/php.ini
sudo docker-compose restart