Index: dv-opendmarc-1.0.0.beta1/db/schema.mysql =================================================================== --- dv-opendmarc-1.0.0.beta1.orig/db/schema.mysql 2012-08-24 20:21:23.000000000 +0200 +++ dv-opendmarc-1.0.0.beta1/db/schema.mysql 2012-10-10 10:10:57.000000000 +0200 @@ -3,6 +3,9 @@ -- Copyright (c) 2012, The Trusted Domain Project. -- All rights reserved. +CREATE DATABASE IF NOT EXISTS opendmarc; +USE opendmarc; + -- A table for mapping domain names and their DMARC policies to IDs CREATE TABLE IF NOT EXISTS domains ( id INT NOT NULL AUTO_INCREMENT, @@ -85,3 +88,11 @@ PRIMARY KEY(id), KEY(message) ); + +-- CREATE USER 'opendmarc'@'localhost' IDENTIFIED BY 'xxx'; +-- GRANT ALL ON opendmarc.* to 'opendmarc'@'localhost'; + +-- to change the password: +-- mysql -p mysql +-- update user set password=PASSWORD("NEW-PASSWORD-HERE") where user='opendmarc'; +-- flush privileges;