//使用rz将下载好的包传进虚拟机
wordpress-5.3.1-zh_CN.tar.gz
//解压
tar xf wordpress-5.3.1-zh_CN.tar.gz -C /var/www/html/
//进入指定目录
cd /var/www/html/wordpress/
//修改文件名
mv wp-config-sample.php wp-config.php
// ** MySQL 设置 - 具体信息来自您正在使用的主机 ** //
/** WordPress数据库的名称 */
define('DB_NAME', 'wordpress');#此项,修改之
/** MySQL数据库用户名 */
define('DB_USER', 'wordpress');#此项,修改之
/** MySQL数据库密码 */
define('DB_PASSWORD', 'wordpress');#此项,修改之
/** MySQL主机 */
define('DB_HOST', 'localhost');#此项,修改之
/** 创建数据表时默认的文字编码 */
define('DB_CHARSET', 'utf8');
/** 数据库整理类型。如不确定请勿更改 */
define('DB_COLLATE', '');
//修改wordpress目录权限
chown -R apache.apache /var/www/html/wordpress/
//进入数据库
mysql
//创建数据库
CREATE DATABASE wordpress;
//创建指定授权用户
GRANT ALL ON wordpress.* TO wordpress@'localhost' IDENTIFIED BY 'wordpress';
//刷新用户权限
FLUSH PRIVILEGES;
//重启服务
systemctl restart httpd.service mariadb.service
浏览器访问192.168.26.37/wordpress/
浏览器访问192.168.26.37/wordpress/wp-admin/可进入后台管理页面
Centos7实现 PowerDNS 应用部署
//配置epel源
yum -y install epel-release
//基于epel源,安装相关服务
yum install -y pdns pdns-backend-mysql mariadb-server httpd
----------------------------------------------
//如果中间出现错误无法安装错误之一解决方法,可忽略
cd /etc/pki/rpm-gpg
wget https://archive.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL-7
----------------------------------------------
//启动数据库
systemctl start mariadb.service httpd.service
//进入数据库
mysql
//创建数据库
CREATE DATABASE powerdns;
//创建用户并赋予权限
GRANT ALL ON powerdns.* TO 'powerdns'@'localhost' IDENTIFIED BY 'powerdns';
//刷新用户权限
FLUSH PRIVILEGES;
//创建powerdns数据库中的表,参看下面文档实现,复制链接百度即可
https://doc.powerdns.com/md/authoritative/backend-generic-mysql/
//创建脚本文件
vim pdns.sql
//内容如下
CREATE TABLE domains (id INT AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
master VARCHAR(128) DEFAULT NULL,
last_check INT DEFAULT NULL,
type VARCHAR(6) NOT NULL,
notified_serial INT DEFAULT NULL,
account VARCHAR(40) DEFAULT NULL,
PRIMARY KEY (id)) Engine=InnoDB;
CREATE UNIQUE INDEX name_index ON domains(name);
CREATE TABLE records (id BIGINT AUTO_INCREMENT,
domain_id INT DEFAULT NULL,
name VARCHAR(255) DEFAULT NULL,
type VARCHAR(10) DEFAULT NULL,
content VARCHAR(64000) DEFAULT NULL,
ttl INT DEFAULT NULL,
prio INT DEFAULT NULL,
change_date INT DEFAULT NULL,
disabled TINYINT(1) DEFAULT 0,
ordername VARCHAR(255) BINARY DEFAULT NULL,
auth TINYINT(1) DEFAULT 1,
PRIMARY KEY (id)) Engine=InnoDB;
CREATE INDEX nametype_index ON records(name,type);
CREATE INDEX domain_id ON records(domain_id);
CREATE INDEX recordorder ON records (domain_id, ordername);
CREATE TABLE supermasters (
ip VARCHAR(64) NOT NULL,
nameserver VARCHAR(255) NOT NULL,
account VARCHAR(40) NOT NULL,
PRIMARY KEY (ip, nameserver)) Engine=InnoDB;
CREATE TABLE comments (id INT AUTO_INCREMENT,
domain_id INT NOT NULL,
name VARCHAR(255) NOT NULL,
type VARCHAR(10) NOT NULL,
modified_at INT NOT NULL,
account VARCHAR(40) NOT NULL,
comment VARCHAR(64000) NOT NULL,
PRIMARY KEY (id)) Engine=InnoDB;
CREATE INDEX comments_domain_id_idx ON comments (domain_id);
CREATE INDEX comments_name_type_idx ON comments (name, type);
CREATE INDEX comments_order_idx ON comments (domain_id, modified_at);
CREATE TABLE domainmetadata (id INT AUTO_INCREMENT,
domain_id INT NOT NULL,
kind VARCHAR(32),
content TEXT,
PRIMARY KEY (id)) Engine=InnoDB;
CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id, kind);
CREATE TABLE cryptokeys (id INT AUTO_INCREMENT,
domain_id INT NOT NULL,
flags INT NOT NULL,
active BOOL,
content TEXT,
PRIMARY KEY(id)) Engine=InnoDB;
CREATE INDEX domainidindex ON cryptokeys(domain_id);
CREATE TABLE tsigkeys (id INT AUTO_INCREMENT,
name VARCHAR(255),
algorithm VARCHAR(50),
secret VARCHAR(255),
PRIMARY KEY (id)) Engine=InnoDB;
CREATE UNIQUE INDEX namealgoindex ON tsigkeys(name, algorithm);
//脚本内容到此结束,为以上内容
----------------------------------------------------------------------
//导入脚本
mysql powerdns < pdns.sql
//编辑pdns配置文件
vim /etc/pdns/pdns.conf
//搜索launch
/launch
//修改launch=bind为以下内容
#launch=bind
launch=gmysql
gmysql-host=localhost
gmysql-port=3306
gmysql-dbname=powerdns
gmysql-user=powerdns
gmysql-password=powerdns
//启动pdns服务,显示端口为53
systemctl start pdns
//查看端口信息
ss -ntl
//安装http和php相关包,没错全部都是
//中文页面有换行,建议先复制一行,空格后再复制下一行
yum -y install httpd php php-devel php-gd php-mcrypt php-imap php-ldap php-mysql
php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-mhash gettext
//重新启动服务/并设置开机自启
systemctl restart httpd.service
systemctl enable --now httpd