#
# $Id$
#
# Create a FANCYMAIL mysql db. 
#
# Copyright (C) 2012 clazzes.org project
#
# Author: wglas
#

DROP DATABASE IF EXISTS FANCYMAIL;

CREATE DATABASE IF NOT EXISTS FANCYMAIL;
USE FANCYMAIL;

GRANT ALL PRIVILEGES
  ON FANCYMAIL.*
  TO fancymail@'localhost'
  IDENTIFIED BY 'liamycnaf!';

GRANT ALL PRIVILEGES
  ON FANCYMAIL.*
  TO fancymail@'%'
  IDENTIFIED BY 'liamycnaf!';
# local conns can also be treated as %, dependend on /etc/hosts content!!!

FLUSH PRIVILEGES;

COMMIT;
