Shell script Connection MySQL database query the number of tables and table names

#!/bin/bashMysqlhost="127.0.0.1"Mysqluser="Root"mysqlpwd="Root"Mysqlport="3306"MySQLdb="Test"Echo"Health Tables Total:">Mysqlcount.txt;mysql-H$MYSQLHOST-U$MYSQLUSER-P$MYSQLPWD-P$MYSQLPORT-D$MYSQLDB-bse"Select COUNT (*) from information_schema.tables where Table_schema =\"$MYSQLDB\";">>Mysqlcountlocal.txt;mysql-H$MYSQLHOST-U$MYSQLUSER-P$MYSQLPWD-P$MYSQLPORT-D$MYSQLDB-bse"Select Table_name,table_rows from Information_schema.tables where Table_schema =\"$MYSQLDB\";">>mysqlcountlocal.txt

The role of the script:

Query How many long tables are in the database and write to the MysqlCountLocal.txt file

Queries the name and number of each table in the library, appended to the MysqlCountLocal.txt file

Shell script Connection MySQL database query the number of tables and table names