| mysql db,user 자동 생성 쉘스크립트 |
| 글 쓴 이 |
linux |
| 날 짜 |
2003년 03월 21일 22시 57분 37초 |
| 본 문 |
#!/bin/sh
ROOTPASS="passwd"
echo -n "ID: "
read ID
echo -n "PASSWD: "
read PASS
echo -n "DATABASE NANE: "
read DNAME
MYSQL="/usr/local/mysql/bin/mysql"
echo "insert into user values('localhost','${ID}',password('${PASS}'),('n','n','
n','n','n','n','n','n','n','n','n','n','n','n');" > /tmp/useradd.sql
echo "create database ${DNAME};" >> /tmp/useradd.sql
echo "insert into db values('%','${DNAME}','${ID}','y','y','y','y','y','y','y'
,'y','y','y');" >> /tmp/useradd.sql
echo "flush privileges;" >> /tmp/useradd.sql
$MYSQL -uroot -p${ROOTPASS} mysql < /tmp/useradd.sql
rm -rf /tmp/useradd.sql
|
|
|
|