Analyze all tables in a mysql database from the command line (bash)

mysql-analyze-all-tables.sh

#!/bin/bash

# To avoid doing things like putting your mysql password on the cli which is not secure
# Use mysql config editor http://dev.mysql.com/doc/refman/5.6/en/mysql-config-editor.html

for table in $(mysql --login-path=mylogins -D database_name -Bse "show tables");
do mysql --login-path=mylogins -D database_name -Bse "analyze table $table";
done

Hello,
With MySQL 5.5 and above, we can use:
mysqlanalyze --login-path=mylogins --databases database_names

Regards,
Harsha