# WordPress 安装和配置

## 环境

- 腾讯云
- CentOS 7.4
- 1C + 1G（最低配置）
- IP：193.112.211.201
	- 推荐按此文章进行安装的时候可以把该 IP 替换成你的，方便直接复制

## 更新系统可更新软件

```
yum clean all
yum -y update
```

## 安装 Apache

```
yum install -y httpd
systemctl start httpd.service
systemctl enable httpd.service
```

- 访问（如果出现 Apache 欢迎页面即表示成功）：<http://193.112.211.201>


## 安装 MySQL

#### 先检查是否已经安装了 Mariadb

- 检查：`rpm -qa | grep mariadb`
- 卸载：`rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64`

#### MySQL 5.5 安装和配置（内存 1G 推荐）

- [MySQL 5.5](Mysql-Install-And-Settings.md)

#### MySQL 5.6 安装和配置（如果内存没有大于 2G，请不要使用）

- [MySQL 5.6](Mysql-Install-And-Settings.md)

#### MySQL 5.7（推荐）

```
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
yum localinstall -y mysql57-community-release-el7-8.noarch.rpm
yum install mysql-community-server

systemctl enable mysqld.service
systemctl restart  mysqld.service
```

#### MySQL 5.7 配置


- 默认 MySQL 5.7 安装完有一个随机密码生成，位置在：`/var/log/mysqld.log`，里面有这样一句话：`A temporary password is generated for root@localhost: 随机密码`
- 如果初次要连上去需要填写该密码
- 我们也可以选择重置密码：
	- `systemctl stop mysqld.service`
	- `/usr/sbin/mysqld --skip-grant-tables --user=mysql`
- 在启动一个终端：`mysql -u root mysql`
	- `UPDATE user SET authentication_string=PASSWORD('新密码') where USER='root';FLUSH PRIVILEGES;` 
	- `GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '上一步的新密码' WITH GRANT OPTION;`
	- `systemctl restart  mysqld.service`
- 试一下：`mysql -h localhost -u root -p` 然后输入密码，在 MySQL 终端输入：`select 1;`
- 如果报：`You must reset your password using ALTER USER statement before executing this statement`，解决办法：

```
set global validate_password_policy=0; #密码强度设为最低等级
set global validate_password_length=6; #密码允许最小长度为6
set password = password('新密码');
FLUSH PRIVILEGES;
```

- YUM 安装的 MySQL 默认配置文件在：`vim /etc/my.cnf`，默认有如下信息，会自己配置的可以改下。

```
# For advice on how to change settings please see                                                                                                                                         
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
 
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
 
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
 
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
```


## 安装 PHP 7

- CentOS 7 默认是 PHP 5.4，版本太低
- 安装过程：<https://www.tecmint.com/install-php-7-in-centos-7/>
- 默认配置文件位置：`vim /etc/php.ini`
- 测试 PHP 安装结果，新建文件：`vim /var/www/html/info.php`

```
<?php
phpinfo();
?>
```

- 浏览器访问（出现 PHP 环境信息表示安装成功）：<http://193.112.211.201/info.php>
- 测试后删除刚刚文件：`rm -rf /var/www/html/info.php`

## 安装 WordPress

- 寻找官网最新版本下载地址（201806 是 4.9.4）：<https://cn.wordpress.org/>

```
cd /var/www/html/

wget https://cn.wordpress.org/wordpress-4.9.4-zh_CN.zip

unzip wordpress-4.9.4-zh_CN.zip

rm -rf wordpress-4.9.4-zh_CN.zip

cd /var/www/html/wordpress && mv * ../

rm -rf /var/www/html/wordpress/

chmod -R 777 /var/www/html/
```

- 修改 Apache 配置文件：`vim /etc/httpd/conf/httpd.conf`

```
旧值：
#ServerName www.example.com:80

改为：
ServerName www.youmeek.com:80

----------------------

旧值：
AllowOverride None

改为：
AllowOverride All

----------------------

旧值：
<IfModule dir_module>
   DirectoryIndex index.html
</IfModule>

改为：
<IfModule dir_module>
   DirectoryIndex index.html index.htm Default.html Default.htm index.php Default.php index.html.var
</IfModule>
```

- 重启 Apache

```
systemctl restart  httpd.service
systemctl enable httpd.service
```


## 创建数据库

- SQL 语句：`CREATE DATABASE wordpress DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;`
	- 如果有数据则直接导入：`/usr/bin/mysql -u root --password=123456 DATABASE_Name < /opt/backup.sql`

## WordPress 在线配置引导

- 浏览器访问：<http://193.112.211.201/wp-admin/setup-config.php>

## DNS 解析

- 我是托管到 DNSPOD，重新指向到新 IP 地址即可

## 常用插件

- JP Markdown
- WP Code Highlight.js
- FooBox Image Lightbox
- WP Super Cache

## 常见问题

- 安装插件出现：`WordPress需要访问您网页服务器的权限。 请输入您的FTP登录凭据以继续`
- 解决办法：`chown -R apache:apache /var/www/html`


## 资料

- <https://blog.csdn.net/qq_35723367/article/details/79544001>
- <https://zhuanlan.zhihu.com/p/36744507>