mysql-grant-drop: exclude `performance_schema' database, consilidate conditionals
authorclinton_admin <clinton_admin@fritz.hcoop.net>
Sat, 25 Apr 2015 22:28:35 +0000 (18:28 -0400)
committerclinton_admin <clinton_admin@fritz.hcoop.net>
Sat, 25 Apr 2015 22:28:35 +0000 (18:28 -0400)
mysql-grant-table-drop

index 3cf59db..316f3e9 100755 (executable)
@@ -16,8 +16,7 @@ MYSQL_DBS=`sudo -H mysqlshow | tail -n +4 | head -n -1 | cut -d' ' -f 2 | xargs`
 #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`
@@ -29,6 +28,5 @@ for DB in $MYSQL_DBS; do
 
        done
 
-       fi # information_schema
-       fi # mysql
+       fi
 done