[mysql] mysql db 생성

#!/usr/local/bin/expect
 
set user [lindex $argv 0]
set passwd [lindex $argv 1]
 
spawn /usr/local/mysql/bin/mysql -p mysql
expect "Enter password: "
sleep 1
send "password\r"
expect "mysql> "
send "create database $user;\r"
expect "mysql> "
send "insert into user values('localhost','$user',password('$passwd'),'n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','','','','','','',''); \r"
expect "mysql> "
send "insert into db values('localhost','$user','$user','y','y','y','y','y','y','y','y','y','y','n','n');\r"
expect "mysql> "
send "flush privileges;\r"
expect "mysql> "
send "exit;\r"