How To Install PowerDNS on Ubuntu 14.04

Install PowerDNS on Ubuntu 14.04

For those of you who didn’t know, PowerDNS is a MySQL-based DNS server, written in C++ and licensed under the GPL. PowerDNS can be managed through a web interface (PowerAdmin). Unlike Bind, PowerDNS can be set up using a multitude of backends such as Bind Zone Files, or various Databases.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple. I will show you through the step by step installation PowerDNS on Ubuntu 14.04.

Install PowerDNS on Ubuntu 14.04

Step 1. First, you need to update the repository on your system.

Step 2. Install MySQL.

By default, MySQL is not hardened. You can secure MySQL using the mysql_secure_installation script. you should read and below each step carefully which will set a root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MySQL.

Step 3. Configuring MySQL.

Edit /etc/mysql/my.cnf to make MySQL to listen all interfaces:

Restart MySQL service:

Step 4. Install the PowerDNS server and MySql backend.

Step 5. Create a PowerDNS Database and User in MySQL.

Log in as a MySQL root and create a new database and tables:

Step 6. Configure PowerDNS.

Remove the existing PowerDNS configuration files:

Create file /etc/powerdns/pdns.d/pdns.local.gmysql.conf file:

Add the following lines and set the correct database name and database user which we created earlier:

Finally, restart the PowerDNS service:

Congratulations! You have successfully installed PowerDNS. Thanks for using this tutorial for installing PowerDNS on Ubuntu 14.04 system.

VPS Manage Service Offer
If you don’t have time to do all of this stuff, or if this is not your area of expertise, we offer a service to do “VPS Manage Service Offer”, starting from $10 (Paypal payment). Please contact us to get the best deal!