HEX
Server: Apache/2.4.52 (Ubuntu)
System: Linux mail.btech-izolacje.pl 5.15.0-140-generic #150-Ubuntu SMP Sat Apr 12 06:00:09 UTC 2025 x86_64
User: pewna6876 (1017)
PHP: 8.2.28
Disabled: NONE
Upload Files
File: //usr/share/doc/pdns-backend-mysql/README.Debian
Instructions on setting up MySQL as a backend for PowerDNS
----------------------------------------------------------

You should create a database yourself and install the schema into
it. On upgrades you should also upgrade the schema.
You can find the upstream recommended schema here:

   /usr/share/pdns-backend-mysql/schema

Just create a database (for example, named pdns) and then feed these
SQL commands to MySQL to get the default schema:

   mysql -u root -p <database> < \
     /usr/share/pdns-backend-mysql/schema/schema.mysql.sql

Then add your data to the database. An example configuration for
PowerDNS is provided in /usr/share/doc/pdns-backend-mysql/examples/.

It is probably a good idea to protect your configuration file, as
it will contain your database password:

   chmod 0640 /etc/powerdns/pdns.d/gmysql.conf
   chgrp pdns /etc/powerdns/pdns.d/gmysql.conf

Note: in previous versions, the Debian packages used
dbconfig-common, and you can continue to use dbconfig
created databases, but you will have to upgrade the schema
manually.