tnb/zzz/init_schema.sh

#!/bin/bash

###############################################################################
# 创建和初始化数据库
###############################################################################

set -e

host='192.168.0.210'
username='test'
password='Test@123456'
db='tnb_account_tdb'
db1='tnb_content_tdb'

sql="CREATE DATABASE ${db} DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;"
sql1="CREATE DATABASE ${db1} DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;"

mysql -h${host} -u${username} -p${password} << EOF
${sql}
${sql1}

use ${db}
source ./tnb_account_init.sql;

use ${db1}
source ./tnb_content_init.sql;
EOF
exit;