[ < ] | [ > ] | [ << ] | [ Up ] | [ >> ] | [Top] | [Contents] | [Index] | [ ? ] | ![]() |
mydns
on your
MySQL server:
$ mysqladmin -h host -u username -p create mydns |
Next, create a user that the mydns
server can use to access the
mydns
database:
$ mysql -h host -u username -p mydns mysql> GRANT SELECT ON mydns.* TO user@localhost IDENTIFIED BY 'password'; |
Finally, create the tables in your database that will hold the DNS data.
The mydns
program has an option that will dump an appropriate set of
CREATE TABLE
statements to the standard output, which you may then
examine and use to create the MyDNS tables.
$ mydns --create-tables | mysql -h host -u username -p mydns |
When you have created the tables, you should have three tables in your
mydns
database, called soa
(see section 4.1 The soa
table),
rr
(see section 4.3 The rr
table), and ptr
(see section 4.2 The ptr
table).
(You can use the mydnsimport
program to import zone data from non-MyDNS
servers. See section 6.3 mydnsimport.)