Version 0.1
<< mysql user 및 db 관리 툴 >>
작성 Shell 프로그래밍
작성자 stone
<<특징
DB를 생성하여 그DB만 핸들링 할수있도록 USER의 권한을
조정했으며 현재 등록된 USER 및 DB 리스트조회및
삭제가능하다.
>>

<<사용법>>
mysqlpass 변수에 mysql의 실행화일 경로를 적어준다.
디폴트는 /usr/local/mysql/bin/mysql로 되어있음.

아래의 내용을
mysqluser.sh 파일(필수) 로 저장한후
chmod +x mysqluser.sh
%mysqluser <--enter





clear
mysqlpass="/usr/local/mysql/bin/mysql"
if [ -s mysqltmp ]
then
rm mysqltmp
fi

echo "============================================================="
echo " MYSQL USER MANAGER "
echo "============================================================="
echo " 1. USER CREATE AND DB CREATE "
echo " 2. DROP USER AND DB DROP "
echo " 3. View USER "
echo " 4. View DATABASE "
echo " 5. EXIT "
echo " ※. EXECUTE,AFTER CONFIRM MYSQL ROOT' PASSWORD "
echo "============================================================="
echo "작업을 선택하세요>>\c"
read job

case $job in
"") echo "값을 입력하세요"
mysqluser.sh;;
"1")

echo "user 생성 db입력:\c"
read db
echo "mysql user입력:\c"
read user
echo "user passwd입력:\c"
read pass
echo "=============================================================\n"
echo "create database $db;" >> mysqltmp

echo "insert into user values ('localhost','$user',password'$pass'),'N','N','N','N','N','N','N','N','N','N','N','N','N','N');">>mysqltmp

echo "insert into db values('localhost','$db','$user','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');" >>mysqltmp

echo "flush privileges;">>mysqltmp
$mysqlpass -uroot -p mysql <mysqltmp
rm mysqltmp
mysqluser.sh
;;

"2")
echo "삭제 user db입력:\c"
read db
echo "삭제 user입력:\c"
read user
echo "delete from user where user='$user';" >>mysqltmp
echo "delete from db where user='$user';" >>mysqltmp

echo "user db를 영구적으로 삭제 할까요[y,n]\c";
read yn
if [ $yn = "y" ]
then
echo "drop database $db;" >>mysqltmp
echo "flush privileges;" >>mysqltmp
fi
$mysqlpass -uroot -p mysql <mysqltmp
rm mysqltmp
mysqluser.sh
;;
"3")
clear
echo "============================================================="
echo " VIEW USER "
echo "============================================================="

echo "select user from user;">>mysqltmp
$mysqlpass -uroot -p mysql <mysqltmp
rm mysqltmp
echo "============================================================="
echo "Press Any key.......................\c"
read dumy
mysqluser.sh
;;
"4")
clear
echo "============================================================="
echo " VIEW DATABASE,USER "
echo "============================================================="

echo "select db,user from db;">>mysqltmp
$mysqlpass -uroot -p mysql <mysqltmp
rm mysqltmp
echo "============================================================="
echo "Press Anykey.......................\c"
read dumy
mysqluser.sh
;;
"5")
exit
;;
esac