shell mysql 建库建表
[root@master ~]# cat mysql_create_db_tables.sh
#!/bin/bash
user=‘root’
passwd=“123456”
mycmd=“mysql -u
u
s
e
r
−
p
user -p
user−ppasswd -S /tmp/mysql.sock1”
for dbname in wg02 wg03 wg04
do
$mycmd -e “create database $dbname;”
$mycmd -e “use $dbname;create table t1(id int, name varchar(18));insert into t1 values(1,‘hehe’)”
done