搭建wordpress

一、检查服务器配置

  2. mysql 3306 端口开放（一般在云服务器厂商处设置）

二、安装mysql

开放root的远程登陆
mysql -u root -p 

use mysql;

update user set host='%' where user='root';

flush privileges;


创建wordpress数据库与相应用户
mysql -u root -p 

create database wordpressdb;

create user 'wordpress'@'localhost' identified by '自定义密码';

grant all on wordpressdb.* to 'wordpress'@'localhost';

flush privileges;


三、安装nginx

sudo apt update

apt install nginx

nginx -v


四、安装PHP

sudo apt install -y php php-fpm php-mysql

php -v
# PHP 7.2.19-0ubuntu0.18.04.1 (cli)


五、下载安装wordpress

wget https://wordpress.org/latest.tar.gz
tar xf latest.tar.gz
cp wordpress/* 你自己设定的路径，例nginx：/var/www/wordpress/html/


注：

如果出现mysql数据库无法连接，

  2. 检查host是否为127.0.0.1:3306
  3. 检查验证方式是否正确
    存为test.php文件
    #!/usr/bin/php <?php $link = mysqli_connect('localhost', 'wordpress', '3327754771@qq'); if (!$link) { die('Could not connect: ' . mysqli_error()); } echo 'Connected successfully'; mysqli_close($link); ?>
    chmod -x test.php ./test.php
    检查是否能正常连接，若出现验证方式错误，则更改数据库账户验证方式
    mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password] in /usr/local/program/testMysql.php on line 3 PHP Warning: mysqli_connect(): (HY000/2054): The server requested authentication method unknown to the client in /usr/local/program/testMysql.php on line 3 PHP Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/program/testMysql.php on line
    更改方式
    ALTER USER 'wordpress'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码'


最是人间留不住，朱颜辞镜花辞树