8 kinit
-k -t /etc
/keytabs
/root.admin.keytab root
/admin
11 vos create
-server afs
-partition a
-name db.
$USERNAME -maxquota 5000
12 fs mkmount
-dir /afs
/.hcoop.net
/common
/.databases
/$USERNAME -vol db.
$USERNAME -rw
13 vos release common.databases
14 fs setacl
-dir /afs
/hcoop.net
/common
/databases
/$USERNAME -acl databases l
15 fs setacl
-dir /afs
/hcoop.net
/common
/databases
/$USERNAME -acl system
:backup rl
16 sudo
-H mysql
-e "CREATE USER '$USERNAME'@'localhost' IDENTIFIED BY '$PASSWORD';"
21 DBNAME
="${USERNAME}_${DBNAME_BASE}"
22 DIR
=/afs
/hcoop.net
/common
/databases
/$USERNAME/mysql
24 kinit
-k -t /etc
/keytabs
/root.admin.keytab root
/admin
28 fs setacl
-dir $DIR -acl mysql rlid
29 fs setacl
-dir $DIR -acl databases none
30 fs setacl
-dir $DIR -acl system
:backup rl
31 mkdir
$DIR/$DBNAME ||
exit
32 chown mysql
:mysql
$DIR/$DBNAME
33 chmod 770 $DIR/$DBNAME
34 ln -sf $DIR/$DBNAME /var
/lib
/mysql
/$DBNAME
35 fs setacl
-dir $DIR/$DBNAME/ -acl mysql all
37 sudo
-H mysql
-e "GRANT CREATE,DROP,SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE VIEW,SHOW VIEW,GRANT OPTION ON * TO '$USERNAME'@'localhost';" $DBNAME
38 sudo
-H mysql
-e "FLUSH PRIVILEGES;"
41 echo "Usage: domtool-mysql [adduser <user> <password> | createdb <user> <table>]"