4e549e60bd341f86f80e5cc8bb17f9553ecde6af
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 ALL ON TABLE * TO '$USERNAME'@$WHERE WITH GRANT OPTION;" $DBNAME
37 sudo
-H mysql
-e "FLUSH PRIVILEGES;"
43 DBNAME
="${USERNAME}_${DBNAME_BASE}"
45 sudo
-H mysql
-e "REVOKE ALL ON TABLE * FROM '$USERNAME'@$WHERE;" $DBNAME
46 sudo
-H mysql
-e "REVOKE GRANT OPTION ON TABLE * FROM '$USERNAME'@$WHERE;" $DBNAME
47 sudo
-H mysql
-e "DROP DATABASE $DBNAME;"
54 DBNAME
="${USERNAME}_${DBNAME_BASE}"
56 sudo
-H mysql
-e "GRANT ALL ON TABLE * TO '$USERNAME'@$WHERE WITH GRANT OPTION;" $DBNAME
60 echo "Usage: domtool-mysql [adduser <user> <password> | passwd <user> <password> | createdb <user> <db> | dropdb <user> <db> | grant <user> <db>]"