[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

2.2 Preparing the database

Now that you have installed MyDNS, you'll need to set up a database and access permissions. First, create a database called 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.)