#echo "Mysql Databases are: $MYSQL_DBS"
for DB in $MYSQL_DBS; do
- if test "$DB" != "information_schema"; then
- if test "$DB" != "mysql"; then
+ if (test "$DB" != "information_schema") && (test "$DB" != "mysql") && (test "$DB" != "performance_schema"); then
USER=${DB%%_*}
MYSQLDB_TABLES=`sudo -H mysqlshow $DB | tail -n +5 | head -n -1 | cut -d' ' -f 2 | xargs`
for TBL in $MYSQLDB_TABLES; do
#echo "OWNER FOR $DB.$TBL is $USER"
- `sudo -H mysql -e "GRANT ALL PRIVILEGES ON $DB.$TBL TO $USER@'%.hcoop.net'"`;
+ sudo -H mysql -e "GRANT ALL PRIVILEGES ON \`$DB\`.\`$TBL\` TO $USER@'%.hcoop.net'";
done
- fi # information_schema
- fi # mysql
+ fi
done