2.4 Database access

Next, create a user that the MyDNS server can use to access the `mydns' database:

MySQL:

$ mysql -h host -u username -p mydns mysql> GRANT SELECT ON mydns.* TO user@localhost IDENTIFIED BY 'password';

PostgreSQL:

$ psql mydns mydns=# CREATE USER user WITH PASSWORD 'password'; mydns=# GRANT SELECT ON soa,soa_id_seq TO user; mydns=# GRANT SELECT ON rr,rr_id_seq TO user;