#!/bin/sh
#
#drop database specdb;
$MYSQL_HOME/bin/mysql -uroot <<!EOF
drop database specdb;
create database specdb;

GRANT ALL PRIVILEGES ON *.* TO spec@localhost IDENTIFIED BY 'spec' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO spec@pdb IDENTIFIED BY 'spec' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO spec@"%" IDENTIFIED BY 'spec' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO spec@"driver" IDENTIFIED BY 'spec' WITH GRANT OPTION;
!EOF
