Powered By Blogger

Wednesday, 11 April 2012

Bash script to create multiple database with different username and password - using by reading multiple files with bash.

#!/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

No comments:

Post a Comment