Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- NEWUSER="$1"
- PASSWORD="$2"
- if [ -z "$NEWUSER" ]; then
- echo "Usage: addmysqluser USERNAME [PASSWORD]"
- exit 0
- fi
- if [ -z "$PASSWORD" ]; then
- PASSWORD=$(pwgen --secure)
- fi
- RESULT=$(echo "SELECT user FROM \`user\`;" |mysql5 mysql |grep $NEWUSER)
- if [ $? == 0 ]; then
- echo "The mysql user '$NEWUSER' already exists."
- exit 1
- fi
- mysql5 -e "GRANT ALL ON \`%_$NEWUSER\`.* TO '$NEWUSER'@'localhost' IDENTIFIED BY '$PASSWORD'"
- #if [ $? > 0 ]; then
- # echo "Could not create new MySQL user."
- # exit 1
- #fi
- echo "Added user '$NEWUSER' with password '$PASSWORD', granting all privileges for database '%_$NEWUSER'."
Add Comment
Please, Sign In to add comment