军哥的lnmp如何用bash创建数据库？

大风起

mysql -u root -p
use mysql;
create database new_db;
insert into mysql.user(Host,User,Password) values("localhost","username",password("password"));
flush privileges;
grant all on new_db.* to 'username'@'localhost' identified by "password";
flush privileges;

lolidc

lolidc 发表于 2014-10-6 10:10

mysql -u root -p
use mysql;
create database new_db;
#!/bin/bash
#用法：将数据库名/用户名用:分隔开，每个一行，写入一个文件，执行脚本+文件名，可创建数据库，并为其分配同名用户
IFS=:
while read dbname dbpassword
do
sql_user='root'
sql_pass='root'
mysql -u $sql_user -p$sql_pass -s <<EOT
create database if not exists $dbname default charset utf8 collate utf8_general_ci;
QUIT
EOT
mysql -u $sql_user -p$sql_pass -s << EOF
insert into mysql.user (Host,User,Password) values ("localhost","$dbname",PASSWORD("$dbpassword"));
flush privileges;
grant all on $dbname.* to $dbname@localhost;
flush privileges;
QUIT
EOF
done < $1

lolidc

#mysql -uroot -proot "create database new_db;"
防水墙