Install PowerDNS and Mysql on FreeBSD 12

1
2
3
4
5

pkg install mysql56-server

sysrc mysql_server="YES"

service mysql-server restart

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16

$ 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"

1

pkg install powerdns