portsnap fetch
portsnap extract
cd /usr/ports/dns/powerdns
make config # select mysql
export BATCH=yes # otherwise you get prompted for a lot of options
make install # this takes a while

pkg info | grep mysql | grep client

• In My case I was using client version 5.6

cd /usr/ports/databases/mysql56-server/
make install

echo "mysql_enable=\"YES\"" > /etc/rc.conf
service mysql-server start

mysqladmin -u root password "CHANGEME"

mysql -p # enter password you changed from CHANGEME

create database powerdns; 
quit;

mysql -p powerdns < /usr/local/share/doc/powerdns/schema.mysql.sql # enter password you changed from CHANGEME