lnmp+数据库分离

一台独立的数据库服务器

yum install -y mariadb   mariadb-server   mariadb-devel

systemctl enable --now mariadb

firewall-cmd --set-default-zone=trusted

setenforce 0

sed -i '/SELINUX/s/enforcing/permissive/' /etc/selinux/config

***************************************************************************

迁移数据

mysqldump wordpress > wordpress.bak

scp wordpress.bak 192.168.2.21:/root/

systemctl stop mariadb

systemctl disable mariadb

mysql

create database wordpress character set utf8mb4;

filush privileges;

exit

mysql wordpress < wordpress.bak

mysql

grant all on wordpress.* to wordpress@"%" identified by "wordpress";

flush privileges;

exit

**********************************************************************************

修改网站信息

vim /usr/local/nginx/html/wp-config.php

define('DB_HOST','192.168.2.21')  新的数据库地址