Aliyun服务器搭建个人网站

# 更新yum源
rpm -Uvh  https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
# 安装mysql
yum -y install mysql-community-server
# 查看mysql版本号
mysql -V

# 启动mysql服务
systemctl start mysqld
# 设置mysql服务为自启动
systemctl enable mysqld
# 查看 /var/log/mysqld.log文件，获取并记录root用户的初始密码
grep 'temporary password' /var/log/mysqld.log

# mysql配置文件，在[mysqld]下添加skip-grant-tables
vim /etc/my.cnf
# 重启mysql服务
service mysqld stop
service mysqld start
# 免密登录mysql，看到enter password直接敲回车
mysql -u root -p
# 输入use mysql
mysql> mysqluse mysql
# 更改root的密码
update user set authentication_string=password('新密码') where user='root';
flush privileges;
# 退出
quit
# 再次重启mysql
service mysqld stop
service mysqld start
# 将 /etc/my.cnf下的skip-grant-tables删除掉
vim /etc/my.cnf

 # -u和root连不连起来都行
 mysql -uroot -p
 mysql -u root -p

# 更改密码强度配置
set global validate_password_policy=LOW;
set global validate_password_length=6;
# 更改密码，长度为6
alter user root identified by '123aA@';
# 刷新系统权限
flush privileges;
# 创建wordpress数据库，必须以;结尾
create database wordpress;
# 创建新用户，使用新密码
create user 'user'@'localhost' identified by 'PASSword123.';
# 赋予用户访问数据库wordpress的权限
grant all privileges on wordpress.* to 'user'@'localhost' identified by 'PASSword123.';
# 使配置生效
flush privileges;
# 退出mysql
quit

# 安装Nginx，
sudo yum install -y nginx

# 开启端口
sudo firewall-cmd --permanent --zone=public --add-service=http
sudo firewall-cmd --permanent --zone=public --add-service=https
sudo firewall-cmd --reload

# 启动Nginx
systemctl start nginx
# 停止Nginx
systemctl stop nginx
# 重启Nginx
systemctl restart nginx
# 查看Nginx状态
systemctl status nginx
# 配置Nginx自启动
systemctl enable nginx
# 紧张Nginx自启动
systemctl disable nginx

vim wp-config.php# 下载wordpress
yum -y install wordpress

# 移动wordpress至网站根目录
mv /usr/share/wordpress /usr/share/nginx/html/wordpress
# 修改Wordpress配置文件
# 进入移动后的wordpress目录下，软连接配置文件wp-config.php
cd /usr/share/nginx/html/wordpress
ln -snf /etc/wordpress/wp-config.php wp-config.php
# 编辑wp-config.php文件
vim wp-config.php

// ** MySQL 设置 - 具体信息来自您正在使用的主机 ** //
/** WordPress数据库的名称 */
define('DB_NAME', 'wordpress');
​
/** MySQL数据库用户名 */
define('DB_USER', 'user');
​
/** MySQL数据库密码 */
define('DB_PASSWORD', 'PASSword123.');
​
/** MySQL主机 */
define('DB_HOST', 'localhost');

# 打开Nginx配置文件
vim /etc/nginx/nginx.conf
# 重启Nginx服务
systemctl restart nginx

server {
    listen       80;
    listen       [::]:80;
    server_name  _;
    root         /usr/share/nginx/html/wordpress;
​
    autoindex on;
    location /{
    index index.html index.php;
    try_files $uri $uri/ /index.php?$args;
    }
    location ~ .php$ {
    fastcgi_pass   127.0.0.1:9000;
    include        fastcgi_params;
    fastcgi_param  SCRIPT_FILENAME $document_root$fastcgi_script_name;
     }  
    # Load configuration files for the default server block.
    include /etc/nginx/default.d/*.conf;
​
    error_page 404 /404.html;
    location = /404.html {
    }
​
    error_page 500 502 503 504 /50x.html;
    location = /50x.html { 
    }
​
}

yum -y install php php-fpm php-mysql
systemctl enable php-fpm
systemctl start php-fpm

# 进入mysql
mysql -uroot -p
# 切换到wordpress数据库
use wordpress;
# 将实例公网IP替换为新域名
update wp_options set option_value = replace(option_value, 'http://实例公网IP', 'http://www.WordPress.EcsQuickStart.com') where option_name = 'home' OR option_name = 'siteurl';
# 退出数据库
exit