#
# $Id: createDB.sql 2383 2006-10-03 16:39:06Z huter $
#
# Copyright (C) 2002-2006 EV-i GmbH.
#
# Author: Andreas Idl/EV-i
#

DROP DATABASE IF EXISTS TEST;

CREATE DATABASE IF NOT EXISTS TEST;
USE TEST;

GRANT ALL PRIVILEGES
  ON TEST.*
  TO test@'localhost'
  IDENTIFIED BY 'test';

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

FLUSH PRIVILEGES;

COMMIT;


