mysql database , user 생성 스크립트

사용 방법

./mysql.sh <database_name> <database_password>

ex) ./mysql.sh mydb password123

#!/bin/bashPASS=$2mysql -uroot -p <<MYSQL_SCRIPTCREATE DATABASE $1;CREATE USER '$1'@'localhost' IDENTIFIED BY '$PASS';GRANT ALL PRIVILEGES ON $1.* TO '$1'@'localhost';FLUSH PRIVILEGES;MYSQL_SCRIPTecho "MySQL user created."echo "Username: $1"echo "Password: $PASS"