craig Site Admin
Joined: 19 Feb 2006 Posts: 40
|
Posted: Tue Feb 28, 2006 7:18 am Post subject: Script to create mysql db and setup admin user. |
|
|
# 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 |
|