How to reset PowerDNS admin password mysql


 

At this knowledge base,  I describe how to reset the admin password on PowerDNS for the MySQL platform.

Step 1: Connect server and MySQL which PowerDNS installed.

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| pdns |
+--------------------+
4 rows in set (0.00 sec)

mysql>

Step 2: Select "Pdns" database and show tables

mysql> use pdns;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+--------------------+
| Tables_in_pdns |
+--------------------+
| comments |
| cryptokeys |
| domainmetadata |
| domains |
| perm_items |
| perm_templ |
| perm_templ_items |
| records |
| supermasters |
| tsigkeys |
| users |
| zone_templ |
| zone_templ_records |
| zones |
+--------------------+
14 rows in set (0.00 sec)

mysql>

Step 3: Show users;

mysql> select * from users
-> ;
+----+-----------+----------------------------------+---------------------+----------------------+---------------------------------+------------+--------+
| id | username | password | fullname | email | description | perm_templ | active |
+----+-----------+----------------------------------+---------------------+----------------------+---------------------------------+------------+--------+
| 1 | admin | 55591012346575fb409142234560019b0 | Administrator | operator@bkm.com.tr | Administrator with full rights. | 1 | 1 |
+----+-----------+----------------------------------+---------------------+----------------------+---------------------------------+------------+--------+
1 rows in set (0.00 sec)

mysql>

Step 4: Use Update command and User ID

Check this Link to create an MD5 hash which we'll use to update the password for specific user id.

And also I found the code which updates password information for the user in PowerDNS. You can get it from this link .

mysql> UPDATE users SET `password` = "201f00b5ca5d65a1c118e5e32431514c" WHERE `id` = 1

Perfect! Now you can login the password which you create.

Tagged In:

I'm a IT Infrastructure and Operations Architect with extensive experience and administration skills and works for Turk Telekom. I provide hardware and software support for the IT Infrastructure and Operations tasks.

205 Total Posts
Follow Me