#!/bin/bash

MYSQLADMIN=/usr/local/mysql/bin/mysqladmin
MYSQL=/usr/local/mysql/bin/mysql

${MYSQLADMIN} -u root drop testdb --password=XXXX -f
${MYSQLADMIN} -u root create testdb --password=XXXX

${MYSQL} -u root testdb --password=XXXX <<EOF
  GRANT ALL PRIVILEGES ON testdb.* TO 'testuser'@'localhost'
  IDENTIFIED BY 'testpassword';
  quit
EOF

${MYSQL} -u testuser testdb --password=testpassword <<EOF
create table TEST 
  (
    PK          int,
    VALUE	int
  ) ENGINE=MyISAM;
insert into TEST (PK,VALUE) values (1,10);
insert into TEST (PK,VALUE) values (2,20);
insert into TEST (PK,VALUE) values (3,30);
EOF

echo ${MYSQL} -u testuser testdb --password=testpassword