사용자 계정 + mysql 계정 추가 스크립트
사용자 계정 + mysql 계정 추가 스크립트
사용자 계정 추가 쉘 스크립트
사용법 => /root/script/newuser 사용자ID
vi /root/script/newuser
------------------------------------------------------------------------------
#!/bin/bash
clear
echo ==================================================================
echo " UserAdd Process Start "
echo ==================================================================
echo -n "User Name : "
read username
useradd $username
echo ------------------------
echo PassWord Setting
echo ------------------------
passwd $username
echo ==================================================================
echo " www root directory making "
echo ==================================================================
echo
echo -n "www root Directory path : "
echo /home/$username/public_html
mkdir -p /home/$username/public_html
echo ==================================================================
echo " root directory setting & test index.php making "
echo ==================================================================
chmod 775 /home/$username
chmod 775 /home/$username/public_html
chown $username.$username /home/$username/public_html
echo " " >>/home/$username/public_html/index.php
echo "<? phpinfo(); ?>" >> /home/$username/public_html/index.php
chown $username.$username /home/$username/public_html/index.php
chmod 775 /home/$username/public_html/index.php
echo checking -----------------------------------------------------------
ls -al /home/$username
echo checking -----------------------------------------------------------
ls -al /home/$username/public_html
echo ==================================================================
echo " MySQL useradd"
echo ==================================================================
echo "Username : $username"
echo "dbname : $username"
echo -n "User p/w : "
read userpw
echo " " >> mysql_useradd.sql
echo "use mysql" >> mysql_useradd.sql
echo "create database $username;" >> mysql_useradd.sql
echo "insert into user (host, user, password) values ('localhost', '$username', password('$userpw'));" >> mysql_useradd.sql
echo "insert into db values ('localhost', '$username', '$username', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');" >> mysql_useradd.sql
echo "FLUSH PRIVILEGES;" >> mysql_useradd.sql
/usr/local/mysql/bin/mysql -uroot -p97081056 < ./mysql_useradd.sql
cat ./mysql_useradd.sql
rm -rf ./mysql_useradd.sql