mysql/mariadb数据库初始化脚本

#!/bin/bash

mysql -u root -p${password} <<EOF

use ${database};

drop user if exists '${username}'@'%';

flush privileges;

create user ${username}identified by '${password}';

grant all privileges on ${username}.* to ${username}@'%' identified by '${password}';

flush privileges;

source ./createTable.sql

source ./initTable.sql

exit

EOF