Mysql数据库应用脚本

创建数据库用户

#!/bin/sh

mysql -u root -p <<END
USE mysql;
CREATE USER 'user';
SET PASSWORD FOR 'user'=PASSWORD('123456');
\q
END

创建数据库并授权用户：

#!/bin/sh
  
mysql -u root -p <<END
CREATE DATABASE $1;
GRANT ALL PRIVILEGES ON  $1.* to $2@localhost;
FLUSH PRIVILEGES
\q
END