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
=/srv
/databases
/${USERNAME:0:1}/${USERNAME:0:2}/$USERNAME/mysql
26 if [ ! -d $DIR ]; then
27 echo WARNING
: $DIR must already exist
!
31 chown mysql
:mysql
$DIR/$DBNAME
32 chmod 770 $DIR/$DBNAME
33 ln -sf $DIR/$DBNAME /var
/lib
/mysql
/$DBNAME
34 chmod g
+rw
-R $DIR/$DBNAME/
35 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
37 sudo
-H mysql
-e "FLUSH PRIVILEGES;"
43 DBNAME
="${USERNAME}_${DBNAME_BASE}"
45 sudo
-H mysql
-e "DROP DATABASE $DBNAME;"
51 DBNAME
="${USERNAME}_${DBNAME_BASE}"
53 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
57 echo "Usage: domtool-mysql [adduser <user> <password> | passwd <user> <password> | createdb <user> <db> | dropdb <user> <db> | grant <user> <db>]"