Count database row number

count_database.sh

#!/bin/bash -x

# To count row number of each table in a schema
# Example: echo 127.0.0.1 root rootpassword rootdatabase | ./count_database.sh 2>/dev/null

while read host username password schema; 
    do
        mysql -h$host -u$username -p$password -Ne "select table_name from information_schema.tables where table_schema='${schema}'"|
        while read table;
            do
                mysql -h$host -u$username -p$password -Ne "select '$schema','$table',count(*) from $schema.$table";
            done
    done