10 sudo
-H mysql
-e "CREATE USER '$USERNAME'@$WHERE IDENTIFIED BY '$PASSWORD';"
17 sudo
-H mysql
-e "SET PASSWORD FOR '$USERNAME'@$WHERE = PASSWORD('$PASSWORD');"
23 DBNAME
="${USERNAME}_${DBNAME_BASE}"
24 DIR
=/afs
/hcoop.net
/common
/databases
/${USERNAME:0:1}/${USERNAME:0:2}/$USERNAME/mysql
26 kinit
-k -t /etc
/keytabs
/root.admin.keytab root
/admin
29 if [ ! -d $DIR ]; then
30 echo WARNING
: $DIR must already exist
!
34 chown mysql
:mysql
$DIR/$DBNAME
35 chmod 770 $DIR/$DBNAME
36 ln -sf $DIR/$DBNAME /var
/lib
/mysql
/$DBNAME
37 fs setacl
-dir $DIR/$DBNAME/ -acl system
:mysql all
38 sudo
-H mysql
-e "GRANT CREATE,CREATE TEMPORARY TABLES,SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE VIEW,SHOW VIEW,LOCK TABLES,GRANT OPTION ON TABLE * TO '$USERNAME'@$WHERE;" $DBNAME
40 sudo
-H mysql
-e "FLUSH PRIVILEGES;"
46 DBNAME
="${USERNAME}_${DBNAME_BASE}"
48 sudo
-H mysql
-e "DROP DATABASE $DBNAME;"
54 DBNAME
="${USERNAME}_${DBNAME_BASE}"
56 sudo
-H mysql
-e "GRANT CREATE,SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE VIEW,SHOW VIEW,LOCK TABLES,GRANT OPTION ON TABLE * TO '$USERNAME'@$WHERE;" $DBNAME
60 echo "Usage: domtool-mysql [adduser <user> <password> | passwd <user> <password> | createdb <user> <db> | dropdb <user> <db> | grant <user> <db>]"