Svenson's Bulletin Board

[craig]

# mysql $DB -uroot -e"grant all on $DB.* to $USR@$FHN identified by '$PSW'"

DB="database_name"

FHN=localhost.localdomain
USR="userid"

PSW="password"
echo "db=$DB,USR=$USR,PSW=$PSW"

ROOTP=rootsmysqlpassword
MYSQL="mysql -u root -p$ROOTP --force mysql"
MYSQLADMIN="mysqladmin -u root -p$ROOTP --force"

echo "Step 0"

$MYSQLADMIN drop $DB

$MYSQL <<EOF
delete from host where db = "$DB";
delete from user where user = "$USR";
delete from db where db = "$DB";
EOF

echo "Step 1"









$MYSQL <<EOF_HT

insert into
host(host,db,Select_priv,Insert_priv,Update_priv,
Delete_priv,Create_priv,Drop_priv,Alter_priv)
values('$FHN','$DB','Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');

EOF_HT
echo "Step 2"




$MYSQL <<EOF_UT

insert into user (host,user,password)
values('$FHN','$USR',password('$PSW'));

EOF_UT

echo "Step 3"



$MYSQL <<EOF_DB

insert into db (host,db,user,Select_priv,Insert_priv,Update_priv,
Delete_priv, Create_priv,Drop_priv,Alter_priv)
values ('$FHN','$DB','$USR','Y','Y','Y','Y','Y','Y','Y');

EOF_DB

echo "Step 4"






$MYSQLADMIN create $DB








$MYSQLADMIN reload




mysql -h$FHN -u$USR -p$PSW $DB <<TEST_EOF

create table tbl1 (
name char(30) not null,
phon char(30) not null,
addr char(30),
primary key(phon,name)
);

show tables;

drop table tbl1;

TEST_EOF