5 echo MySQL user was already created during create-user.
11 sudo
-H mysql
-e "SET PASSWORD FOR '$USERNAME'@'localhost' = PASSWORD('$PASSWORD');"
16 DBNAME
="${USERNAME}_${DBNAME_BASE}"
17 DIR
=/afs
/hcoop.net
/common
/databases
/$USERNAME/mysql
19 kinit
-k -t /etc
/keytabs
/root.admin.keytab root
/admin
23 echo WARNING
: $DIR must already exist
!
27 chown mysql
:mysql
$DIR/$DBNAME
28 chmod 770 $DIR/$DBNAME
29 ln -sf $DIR/$DBNAME /var
/lib
/mysql
/$DBNAME
30 fs setacl
-dir $DIR/$DBNAME/ -acl system
:mysql all
32 sudo
-H mysql
-e "GRANT CREATE,SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE VIEW,SHOW VIEW,GRANT OPTION ON TABLE * TO '$USERNAME'@'localhost';" $DBNAME
33 sudo
-H mysql
-e "FLUSH PRIVILEGES;"
36 echo "Usage: domtool-mysql [adduser <user> <password> | passwd <user> <password> | createdb <user> <table>]"