环境
linux、apache、php-fpm | linux、mariadb | linux client | httpd、powerdns |
---|---|---|---|
192.168.43.17 | 192.168.43.7 | 192.168.43.6 | 192.168.43.27 |
apache_php-fpm | mariadb | client | httpd_powerdns |
配置数据库
创建数据库用户,授权
[mariadb]#
mysql -e "create database powerdns;grant all on powerdns.* to powerdns@'192.168.43.%' identified by 'centos';"
创建powerdns数据库中的表,参看下面文档实现
参考文档
[mariadb]#
mysql
use powerdns;
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