48af512a0e42419c6148c5de793183238e2997e0
8 sudo
-H mysql
-e "CREATE USER '$USERNAME'@'localhost' IDENTIFIED BY '$PASSWORD';"
15 sudo
-H mysql
-e "SET PASSWORD FOR '$USERNAME'@'localhost' = PASSWORD('$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 echo WARNING
: $DIR must already exist
!
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 system
:mysql all
37 sudo
-H mysql
-e "GRANT CREATE,SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE VIEW,SHOW VIEW,GRANT OPTION ON TABLE * TO '$USERNAME'@'localhost';" $DBNAME
38 sudo
-H mysql
-e "FLUSH PRIVILEGES;"
41 echo "Usage: domtool-mysql [adduser <user> <password> | passwd <user> <password> | createdb <user> <table>]"