#!/bin/bash
## copyright vijayakumarcs
MYSQLADM="root"
MYSQLADMPASS="password"
MYSQLADMIP="localhost"
function readfiles()
{
local FD1=7
local FD3=9
local FD2=8
local file1=$1
local file2=$2
local file3=$3
local eof1=0
local eof2=0
local eof3=0
exec 9<$file3
exec 7<$file1
exec 8<$file2
while [[ $eof1 -eq 0 ]]
do
if read data1 <&$FD1;
then
read data2 <&$FD2
read data3 <&$FD3
mysql -u "$MYSQLADM" -h "$MYSQLADMIP" -p"$MYSQLADMPASS" mysql -e "CREATE DATABASE $data1; GRANT ALL PRIVILEGES ON $data1.* TO $data2@localhost IDENTIFIED BY '$data3';"
else
eof1=1
fi
done
}
readfiles user1 user2 user3
## copyright vijayakumarcs
MYSQLADM="root"
MYSQLADMPASS="password"
MYSQLADMIP="localhost"
function readfiles()
{
local FD1=7
local FD3=9
local FD2=8
local file1=$1
local file2=$2
local file3=$3
local eof1=0
local eof2=0
local eof3=0
exec 9<$file3
exec 7<$file1
exec 8<$file2
while [[ $eof1 -eq 0 ]]
do
if read data1 <&$FD1;
then
read data2 <&$FD2
read data3 <&$FD3
mysql -u "$MYSQLADM" -h "$MYSQLADMIP" -p"$MYSQLADMPASS" mysql -e "CREATE DATABASE $data1; GRANT ALL PRIVILEGES ON $data1.* TO $data2@localhost IDENTIFIED BY '$data3';"
else
eof1=1
fi
done
}
readfiles user1 user2 user3

No comments:
Post a Comment