| Server IP : 202.155.9.250 / Your IP : 216.73.216.236 Web Server : LiteSpeed System : Linux srv339029361 5.15.0-177-generic #187-Ubuntu SMP Sat Apr 11 22:54:33 UTC 2026 x86_64 User : lucky4072 ( 1024) PHP Version : 8.0.30 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /usr/share/doc/pdns-backend-mysql/ |
Upload File : |
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.