mysql run command from bash code example

Example 1: run mysql command from bash

mysql --user="$user" --password="$password" --database="$database" --execute="DROP DATABASE $user; CREATE DATABASE $database;"

Example 2: running mysql from bash sc

mysql -u $user -p$passsword -Bse "command1;command2;....;commandn"