Install PowerDNS and Mysql on FreeBSD 12

Database Installation

pkg install mysql56-server

sysrc mysql_server="YES"

service mysql-server restart

Database and User Configuration

$ mysql

mysql> create database powerdns charset = utf8;

mysql> CREATE USER 'powerdns'@'localhost' IDENTIFIED BY 'XianAdmin';

###mysql> GRANT ALL PRIVILEGES ON powerdns.* TO '%' WITH GRANT OPTION;###
mysql> grant all privileges on powerdns.* to 'powerdns'@'localhost' IDENTIFIED BY 'XianAdmin';


mysql> FLUSH PRIVILEGES;


#For security, we also give the main admin password

$ mysqladmin -u root password "PASSWORD_OF_ROOT"

Install powerdns

pkg install powerdns

Reference