DB-hub Technology WordPress

WordPress

Azure WordPress安装

  1. log into Azure
  2. log into MySQL
    mysql -uroot -p
    password: xxxxx
  3. create wordpress database

create database db-hub;

mysql> show databases;
+——————–+
| Database           |
+——————–+
| information_schema |
| mysql              |
| performance_schema |
| sophon             |
| sys                |
| wordpress          |
+——————–+

  1. download wordpress
    https://wordpress.org/download/
  2. FTP to webserver and unzip
    [azureuser@webserver ~]$ pwd
    /home/azureuser
    $ ls -l wordpress-5.5.3.zip
    -rw-rw-r– 1 web web 13221551 Jul 22 18:13 wordpress-5.5.3.zip
  3. make dir under root
    cd /wwwroot
    mkdir sophon
    cp -r /home/azureuser/wordpress/* /wwwroot/sophon/
  4. create user and grant priviledges

create user wp-admin@localhost identified by ‘??????’;
grant all on wordpress.* to wp-admin@localhost;

  1. configure nginx support www.db-hub.net:8080
  2. install wordpress

open your_url/wordpress

change to you database info:
database name:wordpress
user name: wp-admin
password: ??????
host name: localhost

title: Software Technology
username: sophon
password: ??????
ted.liu.2030@gmail.com

10.后台登录:
open your_url/wp-login.php

11.安装Security插件:All In One WP Security & Firewall

WordPress备份

WordPress文件备份

    备份整个网站目录

WordPress数据库备份

    WP安全 -> 数据库安全 -> 数据库备份