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.